Database Management Agent Skills

ClickHouse Analytics Optimization

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

Senior Data Engineer

Builds scalable, production-grade data pipelines and infrastructure using modern tools like Spark, Airflow, and dbt.

ClickHouse Analytics & Optimization

Implements high-performance ClickHouse database patterns, optimized analytical queries, and efficient data engineering workflows.

Database Reviewer Role

Reviews database schemas, migrations, and queries to ensure structural integrity and data safety.

ClickHouse Analytics & Patterns

Optimized analytical query patterns and data engineering best practices for ClickHouse database management.

JPA & Hibernate Patterns for Spring Boot

Optimizes Java persistence layers with production-ready JPA and Hibernate patterns for Spring Boot applications.

Migration Architect

Develops comprehensive strategies for zero-downtime system migrations, database schema evolutions, and robust rollback procedures.

Database Migrations & Schema Management

Guides the implementation of safe, reversible database schema changes and zero-downtime deployments across major SQL databases and ORMs.

Database Engineering Designer

Designs and optimizes engineering-grade database schemas and data models using OpenClaw-native workflows.

CHGIS Temporal Gazetteer

Queries the China Historical GIS Temporal Gazetteer API to retrieve and analyze historical Chinese placenames and administrative structures from 222 BCE to 1911 CE.

dbt Transformation Patterns

Implements production-ready dbt patterns for scalable analytics engineering, model organization, and data quality testing.

Event Sourcing Projection Patterns

Builds high-performance read models and materialized views from event streams using CQRS and projection patterns.

Data Access Layer Architect

Implements robust, repository-pattern data access layers in TypeScript applications to decouple business logic from database implementations.

SQL Optimization Patterns

Optimizes SQL query performance through systematic indexing, EXPLAIN plan analysis, and efficient query refactoring patterns.

Hazel Snowflake Query

Enables Claude to execute accurate SQL queries against Hazel Health’s Snowflake data warehouse using a specialized semantic layer.

Convex Component Authoring

Streamlines the creation and publication of modular, reusable Convex backend components with isolated database schemas and functions.

Data Quality Frameworks

Implements comprehensive data validation using Great Expectations, dbt tests, and data contracts to ensure reliable data pipelines.

DBT Transformation Patterns

Implements production-ready dbt patterns for scalable data transformation, model organization, and analytics engineering best practices.

PostgreSQL Table Design

Architects optimized PostgreSQL database schemas following production-grade best practices for performance, scalability, and data integrity.

SQL Optimization Patterns

Optimizes database performance through advanced indexing strategies, EXPLAIN plan analysis, and query restructuring patterns.

Database Migrations

Manages safe, reversible database schema changes and data migrations using zero-downtime patterns across major ORMs and SQL dialects.

Atlas Migration Workflows

Manages database schema changes through automated planning, linting, and deployment using the Atlas CLI.

Prisma Automation Toolkit

Automates Prisma database operations, schema discovery, and management tasks through the Rube MCP and Composio ecosystem.

Turso Database Automation

Automates Turso database operations and management tasks via the Rube MCP and Composio toolkit.

Prisma Schema Recon

Analyzes and documents Prisma ORM configurations, schemas, and database relations to provide instant project context.

Prisma Developer

Streamlines Prisma ORM configuration, schema design, and migration management for Node.js and TypeScript projects.

Supabase Toolkit

Optimizes Supabase development with automated RLS audits, RPC generation, and database schema validation.

Prisma Database Migrations

Streamlines database schema evolution and version-controlled migration workflows using Prisma Migrate.

Supabase Backend Architect

Architects and implements secure, scalable backend systems using Supabase, Postgres, and Stripe.

Backend Database Architect

Architects and optimizes PostgreSQL and Supabase databases with advanced RLS policies and multi-tenant schema designs.