Database Management Agent Skills

Convex Development

Implement best practices for building robust, secure, and cost-optimized backends using the Convex database.

Trino Query Optimizer

Optimizes Trino query performance and troubleshoots execution issues within Treasure Data environments to reduce costs and latency.

Database Patterns & Optimization

Implements high-performance database migrations, query optimizations, and transaction management patterns for robust data layers.

SQLMesh Data Transformation

Implements advanced data transformation patterns using SQLMesh for efficient incremental processing and column-level lineage.

dbt Analytics Engineering

Simplifies data transformation and analytics engineering by providing standardized dbt patterns, model structures, and testing frameworks.

Reconciliation Patterns

Automates data consistency and recovery between external services and local databases by handling webhook failures and event drift.

Hive SQL Expert

Writes and optimizes Hive SQL queries for Treasure Data environments with a focus on time-based partitioning and performance tuning.

CleanDDD Modeling Architect

Translates structured requirements into CleanDDD modeling blueprints and database DDL scripts for automated code generation.

Prisma Database Management

Automates Prisma-specific database operations, schema management, and migration workflows within Claude Code.

Health Checker

Monitors database health and detects issues like schema drift and connectivity failures across multiple environments.

Treasure Data MCP

Integrates Claude Code with Treasure Data to enable natural language querying, database management, and workflow monitoring via the Model Context Protocol.

AgentDB Advanced Vector Search & Sync

Manages advanced AgentDB features for distributed AI systems, including sub-millisecond QUIC synchronization, hybrid search, and multi-database orchestration.

AgentDB Performance Optimization

Optimizes AgentDB vector databases through quantization, HNSW indexing, and advanced caching to maximize search speed and minimize memory overhead.

Safe Migration Deployer

Deploys database migrations safely across multiple environments with automated health checks and production backups.

dbt for Treasure Data

Provides expert guidance and implementation patterns for using dbt (data build tool) with the Treasure Data Trino engine.

Database Design

Designs efficient database schemas, plans safe migrations, and optimizes queries for relational and document databases using industry-best practices.

SQL Optimization Patterns

Optimizes database performance through systematic query analysis, advanced indexing strategies, and efficient SQL design patterns.

PostgreSQL Table Design

Designs optimized, high-performance PostgreSQL schemas using industry-standard best practices for data integrity and scalability.

Database Migration Guide

Provides expert guidance and automated workflows for migrating databases across engines, versions, and cloud platforms with minimal downtime.

Trino SQL for Treasure Data

Provides expert guidance for writing, optimizing, and debugging Trino SQL queries specifically tailored for the Treasure Data ecosystem.

PostgreSQL Schema & Table Design

Optimizes PostgreSQL database architecture using professional best practices, advanced data typing, and high-performance indexing strategies.

TanStack DB Local-First Development

Builds reactive, local-first applications with sub-millisecond live queries and seamless background data synchronization.

Dataverse Queries

Simplifies retrieving and filtering data from Microsoft Dataverse using optimized OData and SQL syntax.

Knowledge Graph Builder

Architects and implements sophisticated knowledge graphs using semantic relationships and advanced query patterns for Neo4j, RDF, and property graphs.

Data Pipeline Architect

Architects scalable ETL/ELT data pipelines with robust orchestration, error handling, and automated data quality validation.

SQL Query Optimizer

Transforms slow and inefficient SQL queries into high-performance database code through advanced analysis and strategic refactoring.

Supabase Agentic Platform Schema

Deploys standardized Supabase database schemas for tracking AI agent runs, events, artifacts, and tool calls.

PostgreSQL Advanced Patterns

Optimizes PostgreSQL database performance and design through advanced indexing, complex query patterns, and concurrency management.

SQL Query Optimizer

Optimizes database performance by analyzing execution plans, identifying bottlenecks, and rewriting inefficient SQL queries.

LangGraph State Persistence

Implements robust state persistence and checkpointing patterns for LangGraph agents using Memory, SQLite, and Postgres backends.