GitHub
clickhouse-io
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
☆ 60,480Voir le skill
Skills IA blockchain sql databases
Découvrez les skills blockchain sql databases, comparez leurs dépôts et consultez leurs instructions.
Catégories: blockchain sql databases
blockchain sql databases Effacer les filtres
Explorer
GitHub
sql-optimization-patterns
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or...
☆ 27,753Voir le skill
GitHub
database-migration
Execute database migrations across ORMs and platforms with zero-downtime strategies, data transformation, and rollback procedures. Use when migrating databases, changing schemas, performing data transformations...
☆ 27,752Voir le skill
GitHub
postgresql-table-design
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
☆ 27,751Voir le skill
GitHub
postgres-schema-design
Comprehensive PostgreSQL-specific table design reference covering data types, indexing, constraints, performance patterns, and advanced features
☆ 18,940Voir le skill
GitHub
prisma-expert
Prisma ORM expert for schema design, migrations, query optimization, relations modeling, and database operations. Use PROACTIVELY for Prisma schema issues, migration problems, query performance, relation design...
☆ 18,614Voir le skill
GitHub
clickhouse-io
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
☆ 18,614Voir le skill
GitHub
storage-format
SQLite file format, B-trees, pages, cells, overflow, freelist that is used in tursodb
☆ 17,630Voir le skill
GitHub
transaction-correctness
How WAL mechanics, checkpointing, concurrency rules, recovery work in tursodb
☆ 17,630Voir le skill
GitHub
postgresql
PostgreSQL database documentation - SQL queries, database design, administration, performance tuning, and advanced features. Use when working with PostgreSQL databases, writing SQL, or managing database systems...
☆ 12,819Voir le skill
GitHub
timescaledb
TimescaleDB - PostgreSQL extension for high-performance time-series and event data analytics, hypertables, continuous aggregates, compression, and real-time analytics
☆ 12,818Voir le skill
GitHub
query-writing
For writing and executing SQL queries - from simple single-table queries to complex multi-table JOINs and aggregations
☆ 8,916Voir le skill
GitHub
schema-exploration
For discovering and understanding database structure, tables, columns, and relationships
☆ 8,916Voir le skill
GitHub
dsql
Build with Aurora DSQL - manage schemas, execute queries, and handle migrations with DSQL-specific requirements. Use when developing a scalable or distributed database/application or user requests DSQL.
☆ 8,074Voir le skill
GitHub
neon-postgres
Expert patterns for Neon serverless Postgres, branching, connection pooling, and Prisma/Drizzle integration Use when: neon database, serverless postgres, database branching, neon postgres, postgres serverless.
☆ 7,499Voir le skill
GitHub
postgres-query
Run PostgreSQL queries for testing, debugging, and performance analysis. Use when you need to query the database directly, run EXPLAIN ANALYZE, compare query results, or test SQL optimizations. Always uses read...
☆ 7,004Voir le skill
GitHub
query-builder
Convert natural language questions into SQL queries. Activates when users ask data questions in plain English like "show me users who signed up last week" or "find orders over $100".
☆ 4,538Voir le skill
GitHub
schema-designer
Help design database schemas, create tables, and plan data models. Activates when users ask to create tables, design schemas, or model data relationships.
☆ 4,538Voir le skill
GitHub
whodb
Database operations including querying, schema exploration, and data analysis. Activates for tasks involving PostgreSQL, MySQL, MariaDB, SQLite, MongoDB, Redis, Elasticsearch, or ClickHouse databases.
☆ 4,538Voir le skill
GitHub
database-design
Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.
☆ 4,233Voir le skill
GitHub
sql-injection-testing
This skill should be used when the user asks to "test for SQL injection vulnerabilities", "perform SQLi attacks", "bypass authentication using SQL injection", "extract database information through injection", "...
☆ 3,287Voir le skill
GitHub
sqlmap-database-penetration-testing
This skill should be used when the user asks to "automate SQL injection testing," "enumerate database structure," "extract database credentials using sqlmap," "dump tables and columns from a vulnerable database...
☆ 3,287Voir le skill
GitHub
database-design
BK-CI 数据库设计规范与表结构指南，涵盖命名规范、字段类型选择、索引设计、分表策略、数据归档。当用户设计数据库表、优化索引、规划分表策略或进行数据库架构设计时使用。
☆ 2,498Voir le skill
GitHub
postgis-skill
PostGIS-focused SQL tips, tricks and gotchas. Use when in need of dealing with geospatial data in Postgres.
☆ 2,035Voir le skill
Le classement utilise les étoiles du dépôt GitHub indexé. Plusieurs skills peuvent partager ce nombre : ce n’est ni un nombre d’installations ni une note de qualité.