Databases Agent Skills for VS Code

Database schema design principles and patterns.

Enforces standardized PostgreSQL schema design patterns and best practices for robust relational data modeling.

PostgreSQL optimization including indexes, query plans, partitioning, JSONB operations, and connection pooling

Deep operational guide for 15 key-value stores.

Phase 2: The Razor. Filter and merge items based on the Lens.

When to activate: ActiveRecord, includes preload eager_load, N+1 queries, Bullet gem, database migrations, ActiveRecord::Rollback…

Query the witness-anchored ruLake cache — search, verify, explain, or refresh.

Run SQL queries against the WordPress development database.

Formats and executes dbt CLI commands, selects the correct dbt executable, and structures command parameters.

When to activate: Rust database, sqlx, diesel, PostgreSQL, SQLite, MySQL, migrations, queries, connection pools, transactions

Ingest data from S3 into Bauplan safely using branch isolation and quality checks before publishing.

Use when adding/changing DB schema, migrations, RLS/policies, or data backfills.

Use when the user asks to design database schemas, plan data migrations, optimize queries, choose between SQL and NoSQL, or model data…

Optimizes database queries and improves performance across PostgreSQL and MySQL systems.

Zero-downtime migration planning, compatibility validation, and rollback strategy generation.

Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features.

Use when the user asks to write SQL queries, optimize database performance, generate migrations, explore database schemas, or work with…

Optimizes SQL queries, designs database schemas, and troubleshoots performance issues.

Execute read-only SQL queries against multiple PostgreSQL databases.

Azure Cosmos DB SDK for Rust (NoSQL API).

Build table storage applications with Azure Tables SDK for Java.