Databases Agent Skills

SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, and SQL Server.

Analyzes SQL queries for missing indexes, N+1 patterns, suboptimal joins, and full table scans.

Generate parameter bindings for SQL files by analyzing database schema and extracting SQL placeholders.

Write SQL and design indexes that stay fast as data grows — composite index column ordering, keeping predicates sargable, avoiding…

Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis…

Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques.

Write correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.).

Making one SQL statement fast, from its execution plan rather than a guess: reading estimated against actual rows, finding the operation…

Guide for researching SQL syntax and behavior for database backends.

Database Architect skill. Use this when you need to modify the database schema, add tables, or seed data. This project uses RAW SQL…

Reviews SQLAlchemy code for session management, relationships, N+1 queries, and migration patterns.

Use when working with SQLiteData library (@Table, @FetchAll, @FetchOne macros) for SQLite persistence, queries, writes, migrations, or…

General guide for using the sqlite3 CLI to build composable knowledge databases.

Teaches SQLite development including WAL mode, FTS5 full-text search, JSON1 queries, and async Python integration with aiosqlite.

This skill should be used when the user asks to "analyze data with SQLite", "query logs", "find patterns in test results", or "correlate…

SQLite across every host and engine - query performance, concurrency, schema, feature modules, operations.

SQLite performance optimization techniques

When to activate: SQLite, WAL, FTS5, JSON1, pragma, in-memory database, embedded, WASM, SQLite3

Use when working with SQLMesh — writing or editing MODEL blocks, Python @model decorators, Python @macros, audits, unit tests…

SQLx changes since training cutoff (latest: 0.9.0-alpha.1) — SqlSafeStr, owned Arguments, sqlx.toml config, begin_with transactions…

Guide SSOT implementation work after scope freeze, including schema changes, code changes, schema version advancement, migration updates…