Loading...
Loading...
Found 705 Skills
SQL patterns for query optimization, schema design, and data modeling
Write SQL queries, optimize execution plans, and design schemas. Use for query optimization, complex joins, or database design.
Execute use 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".
Execute read-only SQL queries against multiple Microsoft SQL Server databases. Use when: (1) querying MSSQL/SQL Server databases, (2) exploring database schemas/tables, (3) running SELECT queries for data analysis, (4) checking database contents. Supports multiple database connections with descriptions for intelligent auto-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.
Test JSON SQL primitives with semantic-scholar output
Advanced SQL patterns including window functions, CTEs, recursive queries, and optimization techniques.
PostgreSQL-specific schema design, types, and DDL patterns.
Managing legacy MySQL/MariaDB schemas in LAMP stacks.
Creates test data for JSON SQL primitive tests
Execute a fault-tolerant installation and configuration of Prisma ORM v7.4.1 architecture with MySQL.
Write PL/pgSQL - functions, procedures, triggers, error handling
Test the pgsql-parser repository (SQL parser/deparser). Use when working in the pgsql-parser repo, fixing deparser issues, running parser tests, or validating SQL round-trips. Scoped specifically to the constructive-io/pgsql-parser repository.