Databases Agent Skills for VS Code

MySQL and MariaDB schema, query, indexing, transaction, replication, and connection-pool patterns for production backends.

Executes secure, read-only MySQL queries to inspect database schemas and verify table data directly within your development workflow.

Detects N+1 query problems in PHP code. Finds queries in loops, missing eager loading, lazy loading abuse, relationship traversal issues.

Extract and transform Navan booking and transaction data using pagination,

Manage Neon Serverless Postgres via CLI - projects, branches, databases, roles, endpoints, connection strings.

Neon API for serverless Postgres. Use when user mentions "Neon", "Neon

Serverless Postgres with database branching, autoscaling, and scale-to-zero via Neon.

Expert patterns for Neon serverless Postgres, branching, connection

Choose and create the right Neon branch type for testing and development.

Diagnose and fix excessive Postgres egress (network data transfer) in a codebase.

conventions for new columns

Safe database change patterns; when to modify vs add migrations; always pair models with migrations and factories; seeding guidance

Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features

Nosql standards for nosql in Database environments.

Build use when you need to work with NoSQL data modeling.

Expert guidance for distributed NoSQL databases (Cassandra, DynamoDB).

SQL and NoSQL query optimization techniques, indexing strategies, execution plan analysis, JOIN algorithms, cardinality estimation, and…

Add polymorphic activity timelines with live Turbo Stream updates to any Rails model.

Designs and optimizes One Big Table (OBT) patterns

Neutralize and populate Odoo databases via CLI.

Manage Odoo databases via CLI. Covers database creation, duplication, backup, restore, and the --database flag. Enforces the canonical…