Database Management Claude 技能

ClickHouse Cloud Management

Manages ClickHouse Cloud users, permissions, and connections using SQL over the HTTP interface.

Logseq DB Migration Expert

Guides the transition of Logseq knowledge bases from Markdown files to the advanced SQLite database architecture.

Supabase RLS Policy Expert

Generates production-ready, optimized PostgreSQL row-level security (RLS) policies for Supabase databases following security best practices.

Logseq Datalog Expert

Builds and optimizes complex Datalog queries for Logseq's database-driven graphs.

PostgreSQL Table Design

Designs high-performance, production-ready PostgreSQL schemas following industry best practices and modern database patterns.

SQLite Best Practices

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

Postgres SQL Style Guide

Standardizes PostgreSQL development with comprehensive rules for naming conventions, schema design, and query formatting.

Logseq Database Schema Expert

Explains Logseq's Datascript database architecture, including entity relationships, built-in classes, and property type systems.

Cloudflare D1 Migrations & Production Seeding

Manages Cloudflare D1 database schemas, migrations, and environment-specific data seeding using Wrangler and SQL best practices.

Wasp Dev Server Manager

Orchestrates the Wasp development environment by managing local servers, database containers, and schema migrations.

Database Migration & Schema Evolution

Manages complex database migrations across multiple ORMs with zero-downtime strategies and automated rollback procedures.

Supabase PostgreSQL Functions

Generates secure, production-ready PostgreSQL functions and triggers optimized for Supabase databases.

PocketBase API Field Adder

Provides programmatic guidance for adding fields to PocketBase collection schemas using the JavaScript SDK.

Data Wrangler

Transforms and analyzes large datasets using DuckDB SQL directly within the Claude Code environment.

Migration Helper

Facilitates safe database and code migrations using zero-downtime strategies and proven implementation patterns.

Subgraph Migration

Migrates blockchain data indexers from TheGraph subgraphs to Envio HyperIndex for faster performance and modern TypeScript development.

Supabase Typed Query

Builds type-safe, functional Supabase queries using chainable APIs and entity-based CRUD patterns for robust database interactions.

Neo4j Cypher Graph Expert

Integrates Neo4j graph databases with Claude to execute Cypher queries, manage schemas, and explore complex data relationships.

Frappe DocType Builder

Constructs complete DocType definitions for the Frappe Framework, including fields, permissions, and configurations.

Caching Conventions

Enforces standardized caching patterns across React, Next.js, Redis, and Cloudinary layers to ensure consistent data performance and invalidation logic.

Convex Backend Development

Streamlines the implementation of Convex backend features using Zod validation, custom function wrappers, and type-safe database interactions.

NestJS TypeORM Integration

Integrates TypeORM into NestJS projects by configuring data sources, defining entities, managing migrations, and implementing scalable repository patterns.

dbt Development

Validates dbt models against standardized coding conventions to ensure consistent naming, SQL structure, testing coverage, and documentation.

Hono D1 Integration

Integrates Cloudflare D1 database functionality into Hono and TypeScript applications running on Cloudflare Workers or Pages.

Drizzle ORM Development

Enforces database query conventions, type safety, and permission filtering using standardized Drizzle ORM patterns.

Supabase Next.js Integration

Integrates Supabase with Next.js App Router projects using secure patterns for authentication, database management, and row-level security.

Database Management & Optimization

Simplifies database schema design, query optimization, and administration for MongoDB and PostgreSQL environments.

SQL Optimization Patterns

Optimizes SQL query performance through systematic indexing strategies, execution plan analysis, and efficient query patterns.

Query Performance Analysis

Analyzes database query performance, detects N+1 issues, identifies missing indexes, and guides safe index migrations.

Backend Models

Defines and structures database schemas, entities, and relationships while ensuring data integrity and performance through constraints and indexing.