Database Management Agent Skills

Trading MCP Server Configuration

Configures Model Context Protocol (MCP) servers to integrate Claude Code with Alpaca trading APIs and local SQLite databases.

Crypto Trading Database Population

Populates trading databases with cryptocurrency symbols to ensure model availability and enable 24/7 market coverage.

SQL Writer for Game Analytics

Generates, validates, and executes Databricks SQL queries specifically for mobile game analytics and user behavior tracking.

AnomalyArmor Data Intelligence Ask

Queries database metadata and lineage using natural language to uncover table structures, PII, and data relationships.

Data Governance Tags

Classifies and governs database objects through automated tagging for security, compliance, and business organization.

ClickHouse Analytics Patterns

Optimizes high-performance analytical workloads and data engineering using ClickHouse-specific design patterns and best practices.

SQL Guardrails

Enforces strict SQL standards and backend API patterns to prevent injection, data type mismatches, and contract violations.

Event Store Design & Implementation

Designs and implements robust, immutable event stores for event-sourced architectures and high-concurrency backend systems.

Supabase Database Integrator

Configures a PostgreSQL database for ChatGPT Apps using Supabase for persistent data storage and secure user isolation.

History & LocalStorage Manager

Manages persistent state and debate history within localStorage while ensuring data integrity and backward compatibility.

Diagnostic Playground

Generates interactive HTML dashboards populated with real Supabase data to visualize application state and debug complex issues.

JOOQ Database Patterns

Implements type-safe SQL patterns and repository structures for robust database management using JOOQ and Kotlin.

Convex Backend Development

Streamlines Convex backend development with standardized function syntax, schema definitions, and type-safe data modeling.

PostgreSQL Patterns & Best Practices

Optimizes PostgreSQL database architecture, indexing, and security using Supabase-inspired best practices.

Database CLI Assistant

Manages and queries MySQL, PostgreSQL, SQLite, and Redis databases through Claude Code with mandatory schema discovery and safety guardrails.

SQLite Best Practices

Optimizes SQLite database performance and reliability through expert-level configuration and high-performance implementation patterns.

ClickHouse Optimization & Analytics

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

ClickHouse Analytics & Data Engineering

Provides optimized ClickHouse database schemas, high-performance query patterns, and data engineering best practices for OLAP workloads.

Spring Boot JPA & Hibernate Patterns

Provides optimized JPA and Hibernate patterns for building high-performance, scalable Spring Boot data layers.

JPA Patterns for Spring Boot

Implements high-performance JPA and Hibernate data modeling patterns for Spring Boot applications.

PostgreSQL Patterns

Optimizes PostgreSQL schema design, indexing strategies, and query performance using industry-standard best practices.

Postgres Patterns

Optimizes PostgreSQL database schemas, queries, and security configurations using industry-proven patterns and Supabase best practices.

PostgreSQL Patterns & Optimization

Optimizes PostgreSQL database performance and security through standardized schema design, indexing strategies, and performance tuning patterns.

Database Connection Pooler

Optimizes and manages database connection pooling across PostgreSQL, MySQL, and MongoDB environments to ensure high performance and resource efficiency.

Supabase SDK & Auth Setup

Installs and configures the Supabase SDK and CLI while managing authentication credentials for seamless backend integration.

PostgreSQL Fundamentals

Master production-ready SQL foundations and schema design for PostgreSQL 16+ environments.

PocketBase Development

Provides comprehensive guidance and implementation patterns for building real-time backend services using the PocketBase open-source framework.

Supabase Schema Designer

Designs production-ready, normalized database schemas with relationships, constraints, and Row Level Security specifically for Supabase.

SQL Optimization Patterns

Optimizes database performance through advanced indexing strategies, query plan analysis, and efficient data retrieval patterns.

Supabase CRUD Operations

Generates production-ready CRUD operations for Supabase tables with built-in error handling, type safety, and RLS awareness.