mongodb-migration-expert
Database schema design, indexing, and migration guidance for MongoDB-based applications.
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
database-optimizer
Expert database optimizer specializing in query optimization, performance tuning, and scalability across multiple database systems. Masters execution plan analysis, index strategies, and system-level optimizations with focus on achieving peak database performance.
brewcode-grepai
Manages grepai semantic search (setup, status, start, stop, reindex, optimize, upgrade).
memory-optimize
Optimizes Claude Code memory files in 4 interactive steps: removes duplicates, migrates rules to CLAUDE.md/rules files, compresses remaining entries, validates with cleanup. Typical reduction: 30-50% on token count.
db-manage
Database management for Guren with safety checks. Handles migrations, rollbacks, seeding, resets, and container management. Use when user mentions "database", "migration", "migrate", "rollback", "seed", "reset", "db:up", "db:down", "db:reset", "fresh database", or database-related tasks.
add-migration
Add a new SQLite migration to the AntSeed node package. Use when adding tables, columns, or indexes to channel-store or metering databases.
go-cache-caching
Implement caching in Go applications using agentable/go-cache with type-safe generics, pluggable stores, and multi-layer support. Use when adding caching to a service, configuring cache stores (memory, Redis, SQLite, PostgreSQL), setting up multi-layer caching, implementing loader patterns, or choosing codecs.
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.