Loading...
Loading...
Found 1,396 Skills
This skill provides PostgreSQL-specific patterns for database design, optimization, and transaction management
PostgreSQL administration and setup including installation, configuration, backup/recovery, replication, and high-availability. Learn production PostgreSQL operations.
SQL database queries, joins, aggregations, subqueries, and optimization. Use for .sql files and database operations.
Write and format OceanBase database SQL statement documentation following official style guidelines. Use when creating or editing SQL reference documentation for OceanBase database.
Analyze and optimize slow SQL queries. Use when the user says a query is slow, asks to optimize or speed up SQL, wants to find anti-patterns, needs index recommendations, or asks for a query rewrite. Also use when EXPLAIN output shows full table scans or poor join strategies.
SQLite expert for WAL mode, query optimization, embedded patterns, and advanced features
PostgreSQL development best practices for schema design, query optimization, and database administration
SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, SQL Server
Write correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.). Use when writing queries, optimizing slow SQL, translating between dialects, or building complex analytical queries with CTEs, window functions, or aggregations.
SQL query optimization and performance tuning
Managing legacy MySQL/MariaDB schemas in LAMP stacks.
Guidance for Tauri v2 SQL plugin setup, migrations, and safe query access.