Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow…
Step-by-step instructions for designing table schemas and setting up TimescaleDB with hypertables, indexes, compression, retention…
Manages and edits MicroOLAP Database Designer (.pdd) files for PostgreSQL data modeling and schema management.
Migrate an existing Meltano extractor or Singer tap workflow to a Fivetran Connector SDK connector.
This skill should be used when wiki-curator needs to upgrade a vault's schema_version to match the current plugin version.
Review database migration files when a change adds or modifies paths under migrations/.
This skill enables Claude to design NoSQL data models.
Manages MongoDB Atlas Stream Processing (ASP) workflows.
Optimize MongoDB client connection configuration (pools, timeouts, patterns) for any supported driver language.
Interact with a MongoDB database for persistent document storage.
Query documents from a MongoDB collection
Use when optimizing Moodle plugin performance — MUC caching definitions, query optimization, recordsets vs records, ad-hoc and scheduled…
Build or refresh the local Scryfall card database (.mtg/database/cards.sqlite) that the MTG deckbuilding skills read from instead of…
Use when working with the multi-tenant architecture — customer DB switching, FQDN routing, tenant isolation, or cross-tenant operations.
Architects comprehensive database schemas, entity relationships, and data migration strategies for complex software features.
When to activate: MySQL, MariaDB, InnoDB, mysql, JSON column, EXPLAIN, replication, ProxySQL
Guides MySQL/MariaDB query design, indexing strategy, data types, and concurrency patterns — the InnoDB-specific counterpart to…
Diagnosing N+1 query patterns in Rails/Grape: slow index pages, serializers, nested API responses.
Implement incremental sync strategies for Navan BOOKING and TRANSACTION
Implement data quality validation with Great Expectations, dbt tests, and data contracts.
Neo4j CLI. Runs and pipes Cypher, introspects the schema, generates a data model, and embeds text inline as a query parameter. Discovers…