Compare results of two SQL queries to verify if they produce identical data. Checks structure, record count, and data content using MINUS/EXCEPT operations. Use when user needs to validate query equivalence, compare view logic, verify refactoring, or check data consistency.
Interactive SQL mode for 30+ databases using DbCli. Provides REPL environment for exploratory queries, rapid prototyping, and database administration. Includes safety prompts before dangerous operations (UPDATE/DELETE/DROP). Use when user wants interactive database session.
Export database schema objects (procedures, functions, triggers, views, indexes) as SQL scripts for backup
Manage stored procedures, functions, and triggers (CREATE/ALTER/DROP operations)
List all tables in a database and show table structure (columns, types, constraints) for 30+ databases using DbCli. Use when user wants to explore database schema, see what tables exist, check table structure, or understand column definitions.
Execute SELECT queries on 30+ databases (SQLite, SQL Server, MySQL, PostgreSQL, Oracle, etc.) using DbCli. Returns data in JSON, table, or CSV format. Use when user needs to query databases, read data, or execute SELECT statements.
Initialize a PostgreSQL database and user on any configured host
Expert MySQL 8 administration: replication topology, InnoDB Cluster / Group Replication, security hardening, backup strategies with mysqldump/mydumper/xtrabackup, monitoring with Performance Schema, and production operations. Use when setting up...
Use when creating or modifying database migrations in db/migrate. TRIGGER when: editing files in db/migrate/, creating new migrations, adding/removing columns or indexes, changing schema, or user mentions database changes/migrations. DO NOT TRIGGER when: not in a Rails project, editing application code without schema changes.
Check for missing or conflicting Django migrations. Use when models are modified, after scaffolding new endpoints, or before committing. Runs makemigrations --check and validates migration graph consistency. Also use when the user says things like "check migrations", "are migrations up to date", "migration status", or after any model field changes.
Query databases, track tasks, status updates
Processes all open Dependabot PRs sequentially — rebases if needed, analyzes for breaking changes and security issues, then merges or requests changes. Use when you want to handle pending Dependabot dependency updates.
Migrates local docs/*.md fallback files into the MCP Knowledge-DB. Run after MCP outage when local files were created by offline-fallback, or once after MCP setup. With --extract-backlog: Extracts legacy backlogs from status.md directly into MCP docs (replaces mxMigratelegacy).
Create SQL migration files for database schema. Generate .up.sql and .down.sql files using Lokstra CLI. Supports single and multi-database setups with migration.yaml configuration.
Refresh a stable BigQuery-backed Parquet snapshot in the workspace and regenerate recurring dashboard or report artifacts from DuckDB.
Padrões de desenvolvimento com MySQL/MariaDB via SQLdb/Zeos — conexão, stored procedures, AUTO_INCREMENT, JSON, triggers, replication, migrations
TanStack DB reactive client-side database with live queries and optimistic mutations. Use when building reactive UIs with local-first data, sync engines, or optimistic updates. Use for tanstack-db, live queries, optimistic mutations, sync engine, reactive database, local-first.
Guide for using molt verify to compare source and target databases for schema and row-level consistency after a migration. Use when running verify commands, tuning concurrency/sharding, handling schema mismatches, or validating data integrity post-migration.
Guide for using the CockroachDB replicator to continuously replicate changes from PostgreSQL, MySQL, or Oracle to CockroachDB after an initial molt fetch data load. Use when setting up CDC replication, configuring pglogical/mylogical/oraclelogminer, or managing the fetch → replicator cutover workflow.
Guide for using molt fetch to migrate data from PostgreSQL, MySQL, Oracle, or MSSQL to CockroachDB. Use when running molt fetch commands, configuring storage backends, handling fetch failures/resumption, or chaining fetch with verify.
Use this skill when designing database schemas for relational (SQL) or document (NoSQL) databases. Provides normalization guidelines, indexing strategies, migration patterns, and performance optimization techniques. Ensures scalable, maintainable, and performant data models.
