Databases Agent Skills for Codex CLI

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.

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