🗄️SQL and Databases Skills
Browse the best SQL and Databases skills for Claude Code, Codex, Cursor and other AI agents.
1,171 skills · Page 9 of 49
dbt-performance
★ 23Optimizing dbt and Snowflake performance through materialization choices, clustering keys, warehouse sizing, and query optimization. Use this skill when addressing slow model builds, optimizing query performance, sizing warehouses, implementing clustering strategies, or troubleshooting performance issues.
dbt-commands
★ 23dbt command-line operations, model selection syntax, Jinja patterns, troubleshooting, and debugging. Use this skill when running dbt commands, selecting specific models, debugging compilation errors, using Jinja macros, or troubleshooting dbt execution issues.
dbt-materializations
★ 23Choosing and implementing dbt materializations (ephemeral, view, table, incremental, snapshots, Python models). Use this skill when deciding on materialization strategy, implementing incremental models, setting up snapshots for SCD Type 2 tracking, or creating Python models for machine learning workloads.
dbt-modeling
★ 23Writing dbt models with proper CTE patterns, SQL structure, and layer-specific templates. Use this skill when writing or refactoring dbt models, implementing CTE patterns, creating staging/intermediate/mart models, or ensuring proper SQL structure and dependencies.
migration
★ 21Create reversible database migrations with rollback scripts. Use when modifying database schemas.
database-administrator
★ 21Expert database administrator specializing in high-availability systems, performance optimization, and disaster recovery. Masters PostgreSQL, MySQL, MongoDB, and Redis with focus on reliability, scalability, and operational excellence.
database-optimizer
★ 21Expert database optimizer specializing in query optimization, performance tuning, and scalability across multiple database systems. Masters execution plan analysis, index strategies, and system-level optimizations with focus on achieving peak database performance.
database-migration-helper
★ 19Create and manage database migrations safely with rollback support. Use when modifying database schema, adding indexes, or managing database changes.
query-optimizer
★ 19Optimize SQL queries for performance with indexing strategies, query rewriting, and execution plan analysis. Use when queries are slow, optimizing database performance, or analyzing query execution.
schema-designer
★ 19Design database schemas with proper normalization, relationships, constraints, and indexes. Use when creating database tables, modeling data relationships, or designing database structure.
model-builder
★ 19Creates dbt models with proper layering (staging, marts), incremental strategies, and documentation. Use when creating dbt models, organizing data transformations, or implementing incremental models.
database-schema-designer
★ 19Copilot agent for database schema design, ER diagrams, normalization, DDL generation, and performance optimizationTrigger terms: database design, schema design, ER diagram, normalization, DDL, database modeling, relational database, NoSQL design, data modeling, migration planUse when: User requests involve database schema designer tasks.
add-database-table
★ 18Create database migrations, define table schemas, and manage constant tables (enums). Use when: (1) creating a new database table, (2) running 'make migrate.create', (3) adding enum/status values, (4) modifying table structure. REQUIRED first step before add-domain-entity.
text-to-sql
★ 17Setup and use text-to-SQL capabilities for SQL databases (SQLite, PostgreSQL, MySQL, MariaDB, etc.).Use when: (1) User wants to query databases using natural language,(2) User asks to setup text-to-sql project, (3) User mentions extractingdata from database, (4) User has .sqlite/.db file or database credentials andwants to work with data. This skill sets up project structure, extractsdatabase schema, and enables natural language to SQL conversion.
sql
★ 17Guide for working with SQL queries, in particular for SQLite. Use this skill when writing SQL queries, analyzing database schemas, designing migrations, or working with SQLite-related code.
confluent-ksqldb
★ 17ksqlDB stream processing expert. Covers SQL-like queries on Kafka topics, stream and table concepts, joins, aggregations, windowing, materialized views, and real-time data transformations. Activates for ksqldb, ksql, stream processing, kafka sql, real-time analytics, windowing, stream joins, table joins, materialized views.
grey-haven-database-conventions
★ 15Apply Grey Haven database conventions - snake_case fields, multi-tenant with tenant_id and RLS, proper indexing, migrations for Drizzle (TypeScript) and SQLModel (Python). Use when designing schemas, writing database code, creating migrations, setting up RLS policies, or when user mentions 'database', 'schema', 'Drizzle', 'SQLModel', 'migration', 'RLS', 'tenant_id', 'snake_case', 'indexes', or 'foreign keys'.
grey-haven-data-modeling
★ 15Design database schemas for Grey Haven multi-tenant SaaS - SQLModel models, Drizzle schema, multi-tenant isolation with tenant_id and RLS, timestamp fields, foreign keys, indexes, migrations, and relationships. Use when creating database tables.
schema-design
★ 13Design or modify Drizzle ORM schemas with proper relationships, constraints, and indexes. Use when adding new tables, modifying existing schemas, or optimizing database structure.
query-optimization
★ 13Optimize database queries, add indexes, prevent N+1 queries, and improve query performance. Use when queries are slow, investigating database bottlenecks, or optimizing data access patterns.
data-seeding
★ 13Create or update database seed scripts for development and testing environments. Use when setting up test data or initializing development databases.
sql-optimization
★ 12SQL query optimization patterns including EXPLAIN plan analysis, index strategies, query rewriting, and N+1 query prevention. Use when optimizing slow database queries, analyzing query performance, designing indexes, or debugging database bottlenecks. Works with PostgreSQL, MySQL, SQLite, and other SQL databases. Typical improvements: 10x-1000x query speedup.
sql-pro
★ 12Use when optimizing SQL queries, designing database schemas, or tuning database performance. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis. Keywords: SQL, PostgreSQL, MySQL, optimization, EXPLAIN, indexing.
postgres-pro
★ 12Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features. Invoke for EXPLAIN analysis, JSONB operations, extension usage, VACUUM tuning, performance monitoring. Keywords: PostgreSQL, EXPLAIN, replication, JSONB, pg_stat.