Database Management Agent Skills

Event Store Design & Implementation

Design and implement high-performance event stores with robust patterns for event-sourced architectures.

Cloudflare D1 Database Manager

Builds and manages serverless SQLite databases on Cloudflare's edge with automated migrations and performance optimization.

ClickHouse Analytics & Data Engineering

Implements high-performance ClickHouse database patterns, query optimizations, and data engineering best practices for analytical workloads.

Data Engineering & SQL Optimizer

Builds efficient database schemas, optimized SQL queries, and robust ETL pipelines with a focus on data integrity and performance.

Database Migrations

Implements safe, zero-downtime database schema changes and data migrations using industry-standard best practices.

ClickHouse Analytics & Optimization

Provides high-performance patterns and best practices for ClickHouse database design, query optimization, and real-time analytical workloads.

SQL Pro & Database Optimizer

Optimizes complex SQL queries and designs high-performance database schemas across all major database platforms.

Unified Database Management

Streamlines database architecture, query optimization, and management for both MongoDB and PostgreSQL environments.

GraphRAG for PostgreSQL

Automates the design and implementation of GraphRAG systems using PostgreSQL, pgvector, and PGroonga.

WordPress SQL Database Tools

Executes SQL queries against WordPress development databases using Docker Compose to inspect data and debug database issues.

Databases & Data Modeling

Streamlines database management by providing optimized workflows and best practices for both MongoDB and PostgreSQL systems.

Database Migration & Schema Safety

Executes safe database migrations, schema transformations, and zero-downtime data transfers with built-in rollback strategies.

MongoDB Database Explorer

Facilitates read-only MongoDB database interactions, including schema exploration, data querying, and collection analysis.

DuckDB SQL

Generates and refines DuckDB SQL queries for data analysis using local database, CSV, and Parquet files.

Database Migration Patterns

Implements safe, reversible database schema changes and zero-downtime deployments across major SQL databases and ORMs.

Database Schema Designer

Designs and optimizes robust database schemas using engineering-first principles and OpenClaw-native verification.

SQL Syntax Research

Conducts deep research into database-specific SQL syntax and behaviors to ensure precise implementation of SQL translations.

ClickHouse Analytics & Data Engineering

Implements high-performance ClickHouse database patterns, query optimizations, and data engineering best practices for analytical workloads.

TimescaleDB Manager

Optimizes PostgreSQL for high-performance time-series data handling using hypertables and advanced analytics.

Pinecone Vector Database

Integrates Pinecone's high-performance, managed vector database into your AI workflows for scalable RAG and semantic search applications.

Database Smoke Testing

Automates comprehensive database health checks to validate connectivity, performance, and integrity during release cycles.

Salesforce Assistant

Connects Claude to Salesforce environments for executing SOQL queries, exploring metadata, and performing data operations via natural language.

Kysely SQL Database

Simplifies SQL database management using the Kysely type-safe query builder for Expo and Bun environments.

SQLModel Task Modeling

Generates robust, type-safe SQLModel schemas for task-based applications with PostgreSQL optimization and authentication compatibility.

Soul Data Migration

Imports persistent knowledge and memory data from legacy SQLite databases or shared files into the cc-soul environment.

Database Migration Manager

Manages SQLAlchemy database schema changes using Alembic to streamline backend version control and data integrity.

Python Data Engineering

Builds production-grade data pipelines and dimensional models using SQLAlchemy 2.0 and modern warehouse architectures.

SQL Optimization Patterns

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

Migration Checker

Audits database migrations for schema safety, data integrity, and zero-downtime deployment patterns.

ClickHouse Analytics & Data Engineering

Optimizes ClickHouse database performance through high-performance schema design, analytical query patterns, and efficient data ingestion strategies.