Agent Skills Hub

database-patterns

Expert database design and access patterns: schema architecture, indexing strategies, query optimization, repository patterns, and transaction management for SQL and NoSQL databases.

postgresql-table-design

A comprehensive guide for designing high-performance, maintainable PostgreSQL database schemas, covering best practices, data types, indexing, and advanced features.

basic-usage

Essential guide to llmemory for document storage and search: installation, database setup with pgvector, document ingestion, hybrid/semantic retrieval, and building RAG systems with multi-tenant support.

migrate-postgres-tables-to-hypertables

Migrate standard PostgreSQL tables to TimescaleDB hypertables with optimized partitioning, chunking, and compression strategies for time-series data.

agent-database

PostgreSQL schema and migration expert for Diddit. Manages idempotent SQL files, tables, indexes, and constraints following strict camelCase conventions and transactional safety.

railway-database

Provision and manage Railway database services (Postgres, Redis, MySQL, MongoDB) with automated configuration and environment wiring.

event-store-design

Design and implement robust, scalable event stores for event-sourced systems, covering architectural patterns, technology selection, and persistence strategies.

sql-toolkit

Command-line toolkit for SQL database management: schema design, query optimization, migrations, and performance debugging for SQLite, PostgreSQL, and MySQL.

configuring-connection-pools

Optimizes Prisma Client connection pool settings for production databases, serverless environments, and high-concurrency architectures to prevent connection exhaustion and performance bottlenecks.

sql

Executes SQL queries against the WordPress development database for inspection, troubleshooting, and audit log analysis.

database-testing

Database schema validation, data integrity testing, migration validation, transaction isolation, and query performance testing. Ensure ACID compliance and referential integrity for data-driven applications.

neon-toolkit

Automates the lifecycle management of ephemeral Neon PostgreSQL databases for testing, CI/CD, and rapid prototyping workflows.