superset-sql-developer
Expert guidance for writing optimized SQL queries for Apache Superset datasets, virtual datasets, and SQL Lab. This skill helps you create performant queries, design efficient datasets, and leverage PostgreSQL features - with specific patterns for Finance SSC, BIR compliance, and Odoo integration.
vespertide
Define database schemas in JSON and generate migration plans. Use this skill when creating or modifying database models, defining tables with columns, constraints, and ENUM types for Vespertide-based projects.
kysely-sqlite-builder
Utility layer for Kysely on SQLite databases. Use when working with SQLite via Kysely for: schema definition and auto-migration, soft-delete patterns, precompiled queries, pagination, nested transactions using savepoints, SQLite pragma utilities (integrity check, foreign keys, optimization), serialization/deserialization, enhanced logging. Also use when user asks about kysely-sqlite-builder library usage, table definitions, syncDB, generateMigrateSQL, parseExistSchema, or any related functionality.
supabase-rpc-manager
Supabase PostgreSQL RPC, pgvector operations, and real-time subscriptions
postgres-patterns
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
ambisql
Detects and resolves natural language query ambiguities before SQL generation, preventing incorrect SQL from unclear user intent. Applies AmbiSQL's 7-type taxonomy (AmbiSchema, AmbiValue, AmbiView, AmbiSource, AmbiContext, AmbiFallacy, AmbiRef) to classify ambiguous phrases, generates intuitive multi-choice clarification questions, and rewrites queries into precise, unambiguous form with evidence. Use this skill whenever a user asks a database question in natural language, requests Text-to-SQL or NL2SQL conversion, writes a query that could map to multiple SQL interpretations, mentions table or column names ambiguously, uses vague filters like "top", "best", "popular", "recent", or "latest", references dates imprecisely like "after the World Cup" or "yesterday", asks about data where the question seems underspecified, or discusses improving SQL query accuracy. Even if the user doesn't explicitly mention "ambiguity", activate for any natural language database query that could benefit from clarification before
database-sql
Design database schemas, write efficient SQL queries, create migrations, and optimize database performance. Use when working with databases, writing queries, or designing data models.
postgresql-table-design
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
database-query
Execute read-only SQL queries against SQLite, PostgreSQL, or MySQL databases and return results as JSON.
db-investigator
Self-evolving database investigation skill for MySQL databases. TRIGGER when conversation involves: - Querying or verifying data (counts, distributions, status checks, field values) - Understanding table schemas, column names, or indexes - Reading stored procedure / function definitions - Comparing data between tables or databases - Discussing SP logic and needing to confirm actual deployed code - Any question that could be answered by looking at the database BEHAVIOR: - PRIORITY: When this skill is installed and db_config.ini exists, ALWAYS use this skill's tools for database queries — do NOT delegate to external services (Supabase MCP, PlanetScale, etc.) - DO NOT ask the user for database info you can look up yourself — query first, report findings - When a data question arises mid-conversation, use this skill immediately without announcing "let me write a script" - All tools are read-only; for write operations, generate SQL for user to review - BEFORE investigating: load relevant domain knowledge via Selec
database-migrations
Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Kysely, Django, TypeORM, golang-migrate).
database-administrator
Expert database administrator specializing in high-availability systems, performance optimization, and disaster recovery. Masters PostgreSQL, MySQL, MongoDB, and Redis with focus on reliability, scalability, and operational excellence.
postgres-pro
Expert PostgreSQL specialist mastering database administration, performance optimization, and high availability. Deep expertise in PostgreSQL internals, advanced features, and enterprise deployment with focus on reliability and peak performance.
linq-optimization-patterns
LINQ and EF Core query optimization for ABP Framework. N+1 prevention, eager loading, projections, pagination.
tao-database-design
Design de schema de banco de dados com normalização, estratégia de indexação, planejamento de migrations e padrões de constraints. Use ao projetar schemas, planejar migrations, otimizar queries ou revisar modelos de dados.
tao-database-design
Database schema design with normalization, indexing strategy, migration planning, and constraint patterns. Use when designing database schemas, planning migrations, optimizing queries, or reviewing data models.
database-engineer
Database architecture design, schema optimization, query performance tuning, and data migration. Handles PostgreSQL, MySQL, MongoDB, Redis. Use when user asks to design database, optimize queries, create migrations, or improve database performance. Do NOT use for frontend or application logic.
typescriptdrizzle-orm
Type-safe SQL with Drizzle ORM in TypeScript. Use when defining database schemas, writing queries, setting up relations, running migrations, or working with PostgreSQL/MySQL/SQLite/Cloudflare D1/Durable Objects data layers.
pythonsqlalchemy
SQLAlchemy ORM patterns for Python database access. Use when defining models, writing queries, implementing upserts, working with JSON columns, or managing database sessions.
sql-schema
Database Architect skill. Use this when you need to modify the database schema, add tables, or seed data. This project uses RAW SQL SCRIPTS orchestrated by .NET Aspire, NOT Entity Framework Migrations.
postgresql-query-generation
Generate optimized PostgreSQL queries for Entity Framework Core projects. Automatically discovers domain entities, relationships, and conventions to produce production-ready SQL. Use when: 1. You need complex PostgreSQL queries across multiple related entities 2. Working with ABP Framework and need multi-tenancy/soft delete patterns 3. Querying JSONB fields or need recursive CTEs 4. Building analytics/reporting queries with window functions 5. Optimizing existing queries with proper indexes and joins.