Databases Agent Skills for Claude Code

Define clear relationships and load data efficiently; prevent N+1, use constraints, counts/sums, and pivot syncing safely

Cache data in Redis from Encore.ts using `CacheCluster` and typed keyspaces from `encore.dev/storage/cache`.

Work with PostgreSQL in Encore.ts using `SQLDatabase` from `encore.dev/storage/sqldb` — schema migrations and SQL queries.

Work with PostgreSQL in Encore Go using `sqldb.NewDatabase` from `encore.dev/storage/sqldb` — schema migrations and SQL queries.

Trigger: loops, DB queries, rendering, or batch ops.

Automate Neon serverless Postgres operations -- manage projects, branches, databases, roles, and connection URIs via the Composio MCP…

Connect READ-ONLY to a Europharmacy / Euromedica pharmacy SQL Server and run sales / product / stock queries.

Generates Event Store pattern for PHP 8.4.

Use when writing raw SQL — MariaDB/MySQL syntax, parameterization, raw migrations, seeders with `DB::statement`; fires even on a pasted…

Design, implement, or review compatible and reversible database, event, API payload, configuration, or persisted-data schema evolution.

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.