Database Management Agent Skills

Database Design & Optimization

Designs robust database schemas, manages complex migrations, and optimizes SQL queries for peak performance.

Oxy Semantic Layer Builder

Builds and maintains structured Oxy semantic layer files to enable natural language data querying from database schemas.

ETL Pipeline Builder

Builds and extends robust, maintainable ETL pipelines using DLT for API connectors and spreadsheet ingestion.

Research Data Retriever

Retrieves and searches stored research data and survey results from Supabase databases to facilitate knowledge reuse.

Supabase Knowledge Memory

Persists key architectural decisions and technical insights into a Supabase database for long-term project memory.

Prisma ORM Development

Streamlines database schema design, migrations, and type-safe data access using Prisma ORM within TypeScript and JavaScript environments.

Supabase Memory Read

Searches and retrieves historical discussions, design decisions, and domain knowledge from a Supabase-backed long-term memory system.

Research Data & Survey Summarizer

Analyzes and structures raw research data, such as surveys and interviews, into actionable insights stored directly in Supabase.

Supabase CLI Manager

Streamlines Supabase development by managing database migrations, Edge Functions, and local environments using optimized non-interactive commands.

Database Schema Designer

Architects production-grade relational database schemas, migrations, and type definitions from high-level requirements.

Supabase Survey Insights

Retrieves and analyzes survey summaries and interview research data stored in Supabase to provide actionable insights.

Research Data Capturer

Captures and structures conversation-based research and discussions into a Supabase database for long-term knowledge management.

Database Smoke Tester

Validates database connectivity, performance, and integrity across release workflows to ensure production stability.

Prisma Schema & Database Patterns

Optimizes Prisma ORM workflows by enforcing best practices for schema design, migrations, and high-performance query patterns.

Databases & Data Modeling

Optimizes database performance and schema design for both PostgreSQL and MongoDB environments.

Doc Database Management Guide

Develop and maintain the Doc Database VSCode extension for indexing markdown frontmatter into SQLite.

PostgreSQL & Prisma Design Specialist

Designs production-grade PostgreSQL database schemas and optimized Prisma ORM models for Node.js applications.

Field Library Management

Manages structured decision fields and template assignments to ensure consistent, reusable data architecture for organizational decision-making.

PostgreSQL Official Guide

Retrieves real-time, accurate SQL syntax and database configuration details directly from the official PostgreSQL documentation.

Broker Data Reset

Manages and optimizes MCP broker states by purging historical messages and pruning inactive agent registrations.

SproutDB Reference & C# Integration

Provides specialized syntax guidance and implementation patterns for the SproutDB custom database engine and its C# integration.

PostgreSQL Patterns

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

JPA Persistence Patterns

Implements Java Persistence API (JPA) best practices and data modeling patterns within the Claude Code environment.

ClickHouse Data & Analytics Pipeline

Streamlines ClickHouse database management by automating data ingestion, analytical querying, and complex input/output pipelines.

PostgreSQL Design & Performance Patterns

Implements optimized PostgreSQL schemas and query patterns using a structured, evidence-based workflow.

Database Designer

Architects high-performance database schemas and manages complex migrations using expert-level normalization and indexing strategies.

Database Migration & Schema Safety

Automates database schema migrations and query validation to ensure safe rollouts, rollback readiness, and data integrity.

Database Migrations & Schema Patterns

Implements safe, zero-downtime database schema changes and migrations across multiple ORMs and SQL dialects.

Database Schema Designer

Architects optimized relational database schemas and generates migrations, types, and security policies for modern backends.

ClickHouse Analytics Optimizer

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