🗄️SQL and Databases Skills
Browse the best SQL and Databases skills for Claude Code, Codex, Cursor and other AI agents.
1,171 skills · Page 20 of 49
managing-database-replication
★ 1Use when you need to work with database scalability.This skill provides replication and sharding with comprehensive guidance and automation.Trigger with phrases like "set up replication", "implement sharding",or "scale database".
analyzing-query-performance
★ 1Use when you need to work with query optimization.This skill provides query performance analysis with comprehensive guidance and automation.Trigger with phrases like "optimize queries", "analyze performance",or "improve query speed".
validating-database-integrity
★ 1Use when you need to ensure database integrity through comprehensive data validation.This skill validates data types, ranges, formats, referential integrity, and business rules.Trigger with phrases like "validate database data", "implement data validation rules","enforce data integrity constraints", or "validate data formats".
detecting-database-deadlocks
★ 1Use when you need to work with deadlock detection.This skill provides deadlock detection and resolution with comprehensive guidance and automation.Trigger with phrases like "detect deadlocks", "resolve deadlocks",or "prevent deadlocks".
database-documentation-gen
★ 1Use when you need to work with database documentation.This skill provides automated documentation generation with comprehensive guidance and automation.Trigger with phrases like "generate docs", "document schema",or "create database documentation".
text-to-sql
★ 1Convert natural language queries to SQL. Use for database queries, data analysis, and reporting.
lang-sql-dev
★ 1Foundational SQL patterns for query writing, schema design, and dialect differences. Use when writing SQL queries, designing database schemas, understanding SQL syntax across PostgreSQL/MySQL/SQLite, or preparing SQL for conversion to other query languages. This is a meta-skill for SQL derivatives.
generating-stored-procedures
★ 1Use when you need to work with stored procedure generation.This skill provides stored procedure code generation with comprehensive guidance and automation.Trigger with phrases like "generate stored procedures", "create database functions",or "write SQL procedures".
sqlite-db
★ 1SQLite database operations and queries
postgres-db
★ 1PostgreSQL database operations and management
duckdb-spatial
★ 1DuckDB Spatial Skill
osm-topology
★ 1OSM Topology Skill
postgresql
★ 1PostgreSQL DBA skill for schema design review, indexing, query tuning (EXPLAIN/ANALYZE), vacuum/autovacuum, concurrency/locking, partitioning, backup/restore, replication/HA, and safe migrations. Use for tasks like diagnosing slow queries, designing indexes and constraints, and operating Postgres in production.
database-design
★ 1Database schema design, optimization, and migration patterns for PostgreSQL,
database-migrations
★ 1Create and manage database migrations using golang-migrate. Use when creating tables, modifying schemas, adding columns, or managing database structure changes.
data-engineering
★ 1Automatically reviews data pipelines, optimizes SQL queries, and ensures data quality.Activates when you mention: data pipeline, ETL, SQL optimization, query performance,data quality, schema design, Airflow DAG, database index, slow query.Provides: Pipeline design patterns, SQL query optimization, index recommendations,data validation strategies, schema improvements.Supports: PostgreSQL, MySQL, SQLAlchemy, Prisma, Spring Data JPA
mysql
★ 1MySQL DBA skill for schema design review, indexing, query performance tuning (EXPLAIN), transaction/isolation issues, replication/high availability, backup/restore, and operational checklists. Use for tasks like diagnosing slow queries, designing keys/indexes, partitioning strategy, and safe online schema changes.
lang-sparql-dev
★ 1Foundational SPARQL patterns covering RDF querying, triple patterns, graph patterns, and semantic web fundamentals. Use when querying RDF data or working with knowledge graphs. This is the entry point for SPARQL development.
modeling-nosql-data
★ 1Use when you need to work with NoSQL data modeling.This skill provides NoSQL database design with comprehensive guidance and automation.Trigger with phrases like "model NoSQL data", "design document structure",or "optimize NoSQL schema".
managing-database-recovery
★ 1Use when you need to work with database operations.This skill provides database management and optimization with comprehensive guidance and automation.Trigger with phrases like "manage database", "optimize database",or "configure database".
database-patterns
★ 1Database design, optimization, and caching strategies for SQL, NoSQL, and Redis
geospatial-postgis-patterns
★ 1Implement geofences, spatial queries, real-time tracking, and mapping features in laneweaverTMS using PostGIS and PGRouting. Use when building location-based features, distance calculations, ETA predictions, or fleet visualization.
postgres-migrations
★ 1Write safe PostgreSQL migrations that avoid blocking reads/writes. Use when creating migrations, adding columns, indexes, constraints, or modifying tables. Based on Squawk linter rules.
postgresql-replication
★ 1PostgreSQL streaming replication - setup, monitoring, failover