Database Management Claude 技能

TimescaleDB Schema & Hypertable Setup

Streamlines the design and configuration of high-performance TimescaleDB schemas including hypertables, compression, and automated retention policies.

MongoDB Explorer & Query Tool

Enables read-only exploration, schema inspection, and data retrieval from MongoDB databases via MCP integration.

PostgreSQL Migrations

Provides specialized guidance and implementation patterns for resilient, idempotent PostgreSQL database migrations.

Database Architect & Management

Manage and optimize both MongoDB and PostgreSQL environments, from schema design and complex querying to performance tuning and production administration.

TimescaleDB Setup & Optimization

Guides the design and implementation of TimescaleDB hypertables, compression policies, and continuous aggregates for high-performance time-series data.

PostgreSQL pg_dump Reference

Consults the canonical PostgreSQL pg_dump implementation to provide accurate guidance on system catalog queries and schema extraction patterns.

CloudBase DB Web SDK Manager

Integrates CloudBase document database capabilities into web applications for advanced CRUD, aggregation, and geolocation operations.

MongoDB Data Explorer

Enables secure, read-only access to MongoDB databases for schema exploration, data retrieval, and performance analysis.

MongoDB Query & Analysis

Enables read-only exploration and querying of MongoDB databases through the Claude Code environment.

InsForge Schema Patterns

Provides expert PostgreSQL schema patterns and Row Level Security (RLS) policies optimized for InsForge and PostgREST backends.

InsForge Schema Patterns

Provides expert PostgreSQL schema patterns and RLS policies optimized for InsForge and PostgREST applications.

PostgreSQL Syntax Reference

Consults PostgreSQL's internal grammar and parser source code to provide precise SQL syntax and DDL implementation guidance.

Domain Database Specialist

Architects and optimizes scalable data solutions across PostgreSQL, MongoDB, and Redis using advanced persistence patterns.

SQL Optimization Patterns

Optimizes database performance through expert query refactoring, advanced indexing strategies, and detailed execution plan analysis.

SQL Optimization Patterns

Optimizes database performance through advanced SQL query patterns, indexing strategies, and execution plan analysis.

Data Impact & Downstream Lineage

Analyzes data dependencies to determine the impact and blast radius of proposed schema or pipeline changes.

Data Warehouse Schema Discovery

Automates data warehouse schema discovery and generates comprehensive documentation enriched with codebase context for AI-assisted data engineering.

Profiling Tables

Generates comprehensive data profiles and quality assessments for database tables to help engineers and analysts understand dataset structure and health.

Medusa Database Migration Generator

Generates database migration files for specific Medusa modules to synchronize data schemas with your application code.

Medusa Database Migrations

Executes and monitors database migrations for Medusa projects to ensure schema synchronization.

Data Freshness Checker

Verifies the currency and reliability of database tables by analyzing update timestamps and pipeline health.

Ecto Thinking

Applies domain-driven design principles and Ecto best practices to architect robust Elixir database layers.

Ecto Database Essentials

Enforces best practices for Elixir Ecto database schemas, changesets, queries, and migrations.

Bun SQLite

Manages high-performance SQLite database operations using Bun's native driver for seamless data persistence and optimized queries.

Elixir Ecto Patterns

Implements professional database patterns using Elixir's Ecto for robust schema design, data validation, and complex query generation.

Python Data Modeling & Classes

Master Python data structures using dataclasses, attrs, and Pydantic for clean, type-safe modeling and automated validation.

Ecto Schema Patterns

Models robust Elixir data structures using Ecto schemas, complex associations, and embedded data patterns.

Rails Active Record Patterns

Streamlines Ruby on Rails model development by implementing standardized Active Record patterns, associations, and query optimizations.

Ecto Query Patterns

Streamlines Elixir database interactions using Ecto's Query DSL for composable, type-safe, and efficient data retrieval.

PGVector Hybrid Search

Implements production-grade hybrid search using PostgreSQL PGVector and BM25 with Reciprocal Rank Fusion for high-accuracy retrieval.