Databases Agent Skills for VS Code

This skill should be used when the user asks to "rename a column without downtime", "drop a column safely", "add NOT NULL to a live…

Visualize and analyze DataFusion query execution plans.

Connect to and federate external PostgreSQL, MySQL, and SQLite databases with DuckDB.

Use when the user needs to filter data — whether in a structured query, a metric aggregation, or an attribute expression.

Manages Firebase/Firestore operations including CRUD, queries, batch processing, A2A agent communication, MCP server integration, and…

Analyze and consolidate Flyway SQL migrations into clean, domain-grouped CREATE TABLE migrations for pre-production projects.

Conventions and checklist for authoring Flyway SQL migrations (Postgres, Flyway-managed schema).

Expert in event sourcing, CQRS, and event-driven architecture patterns.

Frappe customization-surface guidance covering Custom Field, Property Setter, Client Script, Server Script, Workspace, Web Page, Page…

Frappe DocType creation and form UX guidance.

Manage the freshie ecosystem inventory database \u2014 a CMDB tracking\

Optimize AgentDB performance with quantization (4-32x memory reduction), HNSW indexing (150x faster search), caching, and batch operations.

Implement Command Query Responsibility Segregation for scalable architectures.

Guides PostgreSQL development including table design, indexing, constraints, PL/pgSQL, JSONB, full-text search, window functions, CTEs…

PostgreSQL database patterns for query optimization, schema design, indexing, and security.

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

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

Agent skill for v3-memory-specialist - invoke with $agent-v3-memory-specialist

Produce and structure slow-query performance reports for PostHog's production ClickHouse (US and EU).

Builds geocoding workflows in CARTO that convert street addresses or place names into geographic coordinates.