Database Management Claude 技能

Django Performance Review

Analyzes and validates Django code to identify high-impact performance bottlenecks like N+1 queries, unbounded querysets, and missing database indexes.

Supabase MCP Setup

Streamlines the configuration and troubleshooting of Supabase MCP integrations within the Claude Code environment.

Supabase Database Explorer

Enables seamless exploration and querying of Supabase databases directly through Claude's interface.

MongoDB Management & Optimization

Provides expert guidance on MongoDB schema design, indexing strategies, and aggregation pipeline optimization for high-performance database management.

MongoDB Setup & Troubleshooting

Streamlines the configuration and troubleshooting of MongoDB MCP integrations for Claude Code.

Firebase Firestore Database

Builds and manages scalable NoSQL databases with real-time synchronization, offline support, and advanced querying capabilities.

Axiom Database Migration

Ensures safe database schema evolution and prevents data loss in iOS and macOS applications using SQLite, GRDB, or SwiftData.

Datasette Plugin Development

Provides comprehensive guidance and implementation patterns for building, testing, and deploying custom plugins for the Datasette data exploration tool.

Backend Migration Standards

Creates and manages database migrations with reversible changes, proper naming conventions, and zero-downtime deployment strategies.

Backend Models Standards

Defines robust and maintainable database models with clear naming, appropriate data types, constraints, and relationships.

Database Performance Patterns

Optimizes .NET data access layers using high-performance patterns like CQRS, batching, and efficient querying with EF Core and Dapper.

Upstash Redis KV Store

Interact with Upstash Redis-compatible key-value stores to persist data, manage caches, and handle complex data structures.

Upstash Redis KV Connector

Manages data in Upstash Redis-compatible stores using a comprehensive suite of REST-based commands for caching, state management, and real-time data structures.

PostgreSQL to TimescaleDB Hypertable Migration

Migrates standard PostgreSQL tables to TimescaleDB hypertables using optimized partitioning, chunking, and compression configurations.

PostgreSQL Table Design

Optimizes PostgreSQL database schemas using industry-standard patterns for data types, indexing, and high-performance architecture.

PostgreSQL Hypertable Candidate Finder

Analyzes PostgreSQL database schemas and query patterns to identify tables that would benefit from TimescaleDB hypertable conversion.

TimescaleDB Hypertable Setup

Architects optimized TimescaleDB schemas with hypertables, compression policies, and continuous aggregates for high-performance time-series data.

Snowflake Platform & AI

Develops and deploys applications on Snowflake's AI Data Cloud using snow CLI, Cortex AI, and Native App frameworks.

Relational Database Implementation

Implements robust relational database systems across Python, Rust, Go, and TypeScript using industry-standard ORMs and query builders.

Time-Series Database Implementation

Implements high-performance storage and querying architectures for time-stamped metrics, IoT, and financial data.

Document Database Implementation

Implements flexible-schema NoSQL database patterns including MongoDB, DynamoDB, and Firestore with optimized indexing and aggregation strategies.

Graph Database Implementation

Implements and optimizes graph database architectures for relationship-heavy data models like social networks and recommendation engines.

Data Transformation & Pipelines

Transforms raw data into clean, analytical assets using modern ETL/ELT patterns, SQL (dbt), and high-performance Python frameworks.

Streaming Data & Event-Driven Systems

Builds production-ready event streaming systems and real-time data pipelines using modern brokers like Kafka, Redpanda, and Pulsar.

SQL Performance Optimizer

Optimizes SQL query performance across PostgreSQL, MySQL, and SQL Server through execution plan analysis and strategic indexing.

Data Architecture Strategist

Guides architects through strategic data platform design, storage paradigms, and modeling approaches for modern cloud-native systems.

Data Ingestion Patterns

Streamlines the process of loading data from cloud storage, APIs, and streaming sources into databases using optimized multi-language patterns.

SaaS Database Architect

Simplifies database design and implementation for solo founders using Supabase and PostgreSQL to build secure, multi-tenant SaaS applications.

Query Efficiency Auditor

Audits database query patterns to detect and resolve performance bottlenecks like N+1 loops, redundant fetches, and over-fetching.

Transaction Correctness Auditor

Audits database transaction patterns to ensure data integrity, optimal scope, and proper error handling.