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
228 lines
Indexing Strategies
Index types, design strategies, and maintenance for optimal query performance in relational databases
183 lines
JSON Operations
JSON storage, querying, indexing, and manipulation in PostgreSQL and MySQL for semi-structured data
262 lines
Migration Patterns
Database schema migration strategies for safe, reversible, and zero-downtime changes to production databases
255 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.
131 lines
Query Optimization
Techniques for analyzing and optimizing SQL query performance using execution plans, statistics, and query rewrites
218 lines
Stored Procedures
Stored procedures, functions, and triggers for encapsulating business logic and automating actions within the database
318 lines
Transactions Isolation
Transaction management, ACID properties, isolation levels, and concurrency control in relational databases
226 lines
Window Functions
SQL window functions for analytics, ranking, and running calculations over partitioned result sets
199 lines