Technology & Engineering9 skills

SQL skills for AI agents

9 practitioner-grade sql skills, each a focused Markdown document your agent loads into context on demand. Search them from Claude Desktop, Cursor or any MCP client, or pull one with the CLI.

$ npx skilldb search "sql"

All 9 skills

Ctes Recursive
Common Table Expressions and recursive queries for hierarchical data, graph traversal, and complex query composition
227 lines
Indexing Strategies
Index types, design strategies, and maintenance for optimal query performance in relational databases
182 lines
JSON Operations
JSON storage, querying, indexing, and manipulation in PostgreSQL and MySQL for semi-structured data
261 lines
Migration Patterns
Database schema migration strategies for safe, reversible, and zero-downtime changes to production databases
254 lines
Postgres Operations
Use this skill when working with PostgreSQL specifically. Activate when users mention postgres, postgress, postgresql, psql, EXPLAIN ANALYZE, VACUUM, autovacuum, bloat, WAL, connection pooling with pgbouncer, JSONB, partitioning, logical replication, RLS, or when they need Postgres-specific tuning, migration safety, or incident diagnosis.
130 lines
Query Optimization
Techniques for analyzing and optimizing SQL query performance using execution plans, statistics, and query rewrites
217 lines
Stored Procedures
Stored procedures, functions, and triggers for encapsulating business logic and automating actions within the database
317 lines
Transactions Isolation
Transaction management, ACID properties, isolation levels, and concurrency control in relational databases
225 lines
Window Functions
SQL window functions for analytics, ranking, and running calculations over partitioned result sets
198 lines