Database Management Agent Skills

Event Sourcing & CQRS Architecture

Implements robust event-driven architectures by storing application state as a sequence of immutable domain events for complete auditability and temporal queries.

Database Schema Designer

Designs robust SQL and NoSQL database schemas with a focus on normalization, performance optimization, and safe migration patterns.

PGVector Hybrid Search

Implements production-grade hybrid search using PostgreSQL PGVector and BM25 with Reciprocal Rank Fusion for high-accuracy retrieval.

Database Schema Designer

Designs and optimizes SQL and NoSQL database schemas with professional-grade normalization, indexing, and migration patterns.

Supabase Postgres Best Practices

Optimizes PostgreSQL performance and schema design using production-ready patterns and Supabase-recommended database rules.

Safe Code Migrations

Facilitates secure, backward-compatible software transitions including database schema changes, API versioning, and framework upgrades.

Tidewave MCP Integration for Phoenix

Provides real-time introspection and debugging tools for Elixir Phoenix applications via the Model Context Protocol (MCP).

Ecto Constraint Debugger

Diagnoses and resolves Ecto database constraint violations in Elixir and Phoenix applications.

Ecto N+1 Query Auditor

Identifies and remediates N+1 query anti-patterns in Elixir Ecto code to optimize database performance.

GRDB SQLite for Swift

Implements type-safe SQLite database layers, complex SQL queries, and reactive data observation using GRDB.swift.

SQLite Data for Swift

Simplifies type-safe SQLite persistence and CloudKit synchronization for Swift applications using modern macros and property wrappers.

Database Migration

Executes safe, data-loss-free database schema evolution for iOS and macOS applications using production-ready patterns for SQLite, GRDB, and SwiftData.

SwiftData Migration Diagnostics

Diagnoses and resolves SwiftData migration failures, including schema version mismatches, relationship integrity errors, and data loss across iOS platforms.

SQLiteData Advanced Reference

Provides advanced schema composition, polymorphic data modeling, and complex query patterns for SQLiteData in Swift applications.

GRDB

Facilitates direct SQLite access and advanced database management patterns for iOS and macOS development using GRDB.swift.

SwiftData to SQLiteData Migration

Guides the migration of xOS data layers from SwiftData to SQLiteData to achieve better performance and advanced CloudKit sharing capabilities.

Realm to SwiftData Migration

Provides a comprehensive reference and implementation path for migrating xOS applications from Realm to SwiftData.

PostgreSQL Design & Performance Patterns

Implements high-performance PostgreSQL database schemas, optimized queries, and robust security policies based on industry best practices.

JPA Patterns for Spring Boot

Optimizes Spring Boot data access layers with high-performance JPA and Hibernate design patterns.

PostgreSQL Patterns

Optimizes PostgreSQL database design and performance using industry-standard best practices and patterns.

ClickHouse Analytics & Data Engineering

Optimizes ClickHouse database schemas, queries, and data pipelines for high-performance analytical workloads.

ClickHouse Analytics & Data Engineering

Optimizes ClickHouse database performance with specialized table patterns, query optimization, and real-time analytical workflows.

SwiftData Migration

Implements complex SwiftData schema migrations using versioned schemas, two-stage transformation patterns, and relationship preservation strategies for iOS applications.

Neon Serverless Database Connector

Integrates the Neon Serverless Driver into applications to enable low-latency PostgreSQL access in edge and serverless environments.

Neon Drizzle Database Setup

Automates the configuration of Drizzle ORM with Neon databases, including schema generation and migration workflows.

Neon JS SDK Integration

Configures the full Neon JS SDK for unified authentication and PostgREST-style database queries in modern web applications.

Neon Toolkit

Automates the lifecycle of ephemeral Neon databases for automated testing, CI/CD pipelines, and isolated development environments.

Data Pipeline & ETL Discovery

Automatically activates specialized data engineering skills for ETL, batch processing, and real-time stream orchestration.

Database Skills Discovery

Automatically identifies and loads specialized skills for SQL, NoSQL, schema design, and query optimization within the Claude Code environment.

Snowflake SQL Optimizer

Optimizes Snowflake SQL queries for peak performance by identifying anti-patterns and rewriting logic while preserving exact results.