Databases Agent Skills for Codex CLI

Implements optimized Spring Boot data persistence layers using expert JPA and Hibernate implementation patterns.

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

Use when deploying a database to Zeabur.

Guides and best practices for working with Neon Serverless Postgres.

Quick reference for common SQL patterns, CTEs, window functions, and indexing strategies.

Parses, edits, and generates A5:SQL Mk-2 ER diagram (.a5er) files safely while maintaining formatting integrity and reference consistency.

Master advanced AgentDB features including QUIC synchronization, multi-database management, custom distance metrics, hybrid search, and…

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

Optional advanced tool for complex data modeling.

Database schema design, migrations, query optimization with SQL, Exposed ORM, Flyway.

Use this skill when a read model genuinely needs an IReducerFor<T> — when model-bound projection attributes and fluent IProjectionFor<T>…

JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in…

JetBrains Exposed ORM patterns including DSL queries, DAO pattern, transactions, HikariCP connection pooling, Flyway migrations, and…

Redis data structure patterns, caching strategies, distributed locks, rate limiting, pub/sub, and connection management for production…

Airtable API integration with managed OAuth.

Implement database sharding for horizontal scalability.

Implement event sourcing and CQRS patterns using event stores, aggregates, and projections.

Analyze and optimize SQL queries for performance.

Use this skill whenever a user wants to execute operations against Algolia indices or accounts — deleting records, copying/migrating…

Implement Algolia data handling: record transforms, PII filtering before

Upgrade algoliasearch from v4 to v5 with breaking change detection and