๐๏ธSQL and Databases Skills
Browse the best SQL and Databases skills for Claude Code, Codex, Cursor and other AI agents.
1,171 skills ยท Page 1 of 49
drizzle-orm-d1
โ
109Build type-safe D1 databases with Drizzle ORM for Cloudflare Workers. Includes schema definition, migrationswith Drizzle Kit, relations, and D1 batch API patterns. Prevents 12 errors including SQL BEGIN failures.Use when: defining D1 schemas, managing migrations, writing type-safe queries, implementing relations orprepared statements, using batch API for transactions, or troubleshooting D1_ERROR, BEGIN TRANSACTION,foreign keys, migration apply, or schema inference errors.Prevents 12 documented issues: D1 transaction errors (SQL BEGIN not supported), foreign keyconstraint failures during migrations, module import errors with Wrangler, D1 binding not found,migration apply failures, schema TypeScript inference errors, prepared statement caching issues,transaction rollback patterns, TypeScript strict mode errors, drizzle.config.ts not found,remote vs local database confusion, and wrangler.toml vs wrangler.jsonc mixing.Keywords: drizzle orm, drizzle d1, type-safe sql, drizzle schema, drizzle migration
dbt-data-transformation
โ
26Complete guide for dbt data transformation including models, tests, documentation, incremental builds, macros, packages, and production workflows
safe-migrate
Safely creates and applies database migrations with automatic destructive operation detection, backup creation, and rollback generation. This skill should be used when creating database migrations, applying schema changes, or performing any database DDL operations. Essential for preventing data loss.
database-administrator
Copilot agent that assists with database operations, performance tuning, backup/recovery, monitoring, and high availability configurationTrigger terms: database administration, DBA, database tuning, performance tuning, backup recovery, high availability, database monitoring, query optimization, index optimizationUse when: User requests involve database administrator tasks.
senior-data-engineer
World-class data engineering skill for building scalable data pipelines, ETL/ELT systems, and data infrastructure. Expertise in Python, SQL, Spark, Airflow, dbt, Kafka, and modern data stack. Includes data modeling, pipeline orchestration, data quality, and DataOps. Use when designing data architectures, building data pipelines, optimizing data workflows, or implementing data governance.
postgresql-database-engineering
โ
26Comprehensive PostgreSQL database engineering skill covering indexing strategies, query optimization, performance tuning, partitioning, replication, backup and recovery, high availability, and production database management. Master advanced PostgreSQL features including MVCC, VACUUM operations, connection pooling, monitoring, and scalability patterns.
postgres-pro
โ
21Expert PostgreSQL specialist mastering database administration, performance optimization, and high availability. Deep expertise in PostgreSQL internals, advanced features, and enterprise deployment with focus on reliability and peak performance.
sf-soql
โ
17Advanced SOQL skill with natural language to query generation, query optimization, relationship traversal, aggregate functions, and performance analysis. Build efficient queries that respect governor limits and security requirements.
backend-prisma
โ
4Type-safe database ORM for TypeScript/Node.js. Use when you need database access with full TypeScript integration โ auto-generated types from schema, migrations, and query builder. Best for PostgreSQL, MySQL, SQLite, MongoDB. Choose Prisma over raw SQL or Knex when type safety and developer experience are priorities.
data-modeling
โ
3Use when designing data models, database schemas, or choosing between modeling approaches. Covers dimensional modeling, star schema, data vault, entity-relationship design, and schema evolution.
activerecord-query-patterns
โ
1Complete guide to ActiveRecord query optimization, associations, scopes, and PostgreSQL-specific patterns. Use this skill when writing database queries, designing model associations, creating migrations, optimizing query performance, or debugging N+1 queries and grouping errors. Trigger keywords: database, models, associations, validations, queries, ActiveRecord, scopes, migrations, N+1, PostgreSQL, indexes, eager loading
database
Database design, SQL, NoSQL, and data management patterns
sql
SQL patterns for database querying and design
supabase-expert
Expert guide for Supabase integration - database schemas, RLS policies, auth, Edge Functions, and real-time subscriptions. Use when working with Supabase backend features.
drizzle-orm
TypeScript-first ORM patterns for PostgreSQL, MySQL, and SQLite. Use when writing database schemas, queries, migrations, relations, or transactions with Drizzle ORM.
bq-query-optimization
Use when writing BigQuery queries, optimizing query performance, analyzing execution plans, or avoiding common SQL gotchas. Covers parameterized queries, UDFs, scripting, window functions (QUALIFY, ROW_NUMBER, RANK, LEAD/LAG), JSON functions, ARRAY/STRUCT operations, BigQuery-specific features (EXCEPT, REPLACE, SAFE_*), CTE re-execution issues, NOT IN with NULLs, DML performance, Standard vs Legacy SQL, and performance best practices.
sqlalchemy-20
Modern async ORM with type-safe models and efficient queries
postgres-schema-design
Comprehensive PostgreSQL-specific table design reference covering data types, indexing, constraints, performance patterns, and advanced features. Use when designing database schemas, creating tables, or reviewing database structure.
bq-query-optimization
Use when writing BigQuery queries, optimizing query performance, analyzing execution plans, or avoiding common SQL gotchas. Covers parameterized queries, UDFs, scripting, window functions (QUALIFY, ROW_NUMBER, RANK, LEAD/LAG), JSON functions, ARRAY/STRUCT operations, BigQuery-specific features (EXCEPT, REPLACE, SAFE_*), CTE re-execution issues, NOT IN with NULLs, DML performance, Standard vs Legacy SQL, and performance best practices.
database
Universal database operations skill for modern applications. Expert in SQLModel/SQLAlchemy patterns, async database operations, connection pooling, migrations, performance optimization, and multi-database support (PostgreSQL, MySQL, SQLite). Provides production-ready patterns for any database-driven application.
data-wrangler
Transform and export data using DuckDB SQL. Read CSV/Parquet/JSON/Excel/databases, apply SQL transformations (joins, aggregations, PIVOT/UNPIVOT, sampling), and optionally write results to files. Use when the user wants to: (1) Clean, filter, or transform data, (2) Join multiple data sources, (3) Convert between formats (CSVโParquet, etc.), (4) Create partitioned datasets, (5) Sample large datasets, (6) Export query results. Prefer this over in-context reasoning for datasets with thousands of rows or complex transformations.
duckdb
Fast in-process analytical database for SQL queries on DataFrames, CSV, Parquet, JSON files, and more. Use when user wants to perform SQL analytics on data files or Python DataFrames (pandas, Polars), run complex aggregations, joins, or window functions, or query external data sources without loading into memory. Best for analytical workloads, OLAP queries, and data exploration.
sql-expert
PostgreSQL, MySQL, SQLite, ๋ฐ SQL Server๋ฅผ ์ง์ํ๋ ์ ๋ฌธ๊ฐ ์์ค์ SQL ์ฟผ๋ฆฌ ์์ฑ, ์ต์ ํ ๋ฐ ๋ฐ์ดํฐ๋ฒ ์ด์ค ์คํค๋ง ์ค๊ณ์ ๋๋ค. ๋ฐ์ดํฐ๋ฒ ์ด์ค ์์ ์ ๋ค์์ ์ํด ์ฌ์ฉํ์ธ์: (1) JOIN, ์๋ธ์ฟผ๋ฆฌ, ์๋์ฐ ํจ์๋ฅผ ํฌํจํ ๋ณต์กํ SQL ์ฟผ๋ฆฌ ์์ฑ, (2) ๋๋ฆฐ ์ฟผ๋ฆฌ ์ต์ ํ ๋ฐ ์คํ ๊ณํ ๋ถ์, (3) ์ฌ๋ฐ๋ฅธ ์ ๊ทํ๋ฅผ ์ ์ฉํ ๋ฐ์ดํฐ๋ฒ ์ด์ค ์คํค๋ง ์ค๊ณ, (4) ์ธ๋ฑ์ค ์์ฑ ๋ฐ ์ฟผ๋ฆฌ ์ฑ๋ฅ ๊ฐ์ , (5) ๋ง์ด๊ทธ๋ ์ด์ ์์ฑ ๋ฐ ์คํค๋ง ๋ณ๊ฒฝ ์ฒ๋ฆฌ, (6) SQL ์๋ฌ ๋ฐ ์ฟผ๋ฆฌ ๋ฌธ์ ๋๋ฒ๊น
prisma-v7
Expert guidance for Prisma ORM v7 (7.0+). Use when working with Prisma schema files, migrations, Prisma Client queries, database setup, or when the user mentions Prisma, schema.prisma, @prisma/client, database models, or ORM. Covers ESM modules, driver adapters, prisma.config.ts, Rust-free client, and migration from v6.