Database Management Claude 技能

Go MySQL & sqlx Patterns

Implements production-grade MySQL database access in Go using sqlx with best practices for pooling, transactions, and repository patterns.

Drizzle Cube Definition

Simplifies the creation of secure, type-safe semantic layer cube definitions for Drizzle ORM-based applications.

Neon Postgres Patterns

Implements expert patterns for Neon serverless Postgres, including database branching, connection pooling, and ORM integrations.

Supabase Expert

Architects and implements production-grade Supabase solutions including advanced PostgreSQL RLS, Auth flows, and Edge Functions.

ER Diagram and Data Modeling

Generates entity-relationship diagrams and provides expert data modeling guidance for robust database schema design.

PostgreSQL & Alembic Database Management

Manages PostgreSQL administration, Alembic migrations, and schema design for the SmartEM ecosystem.

Supabase CLI

Manages Supabase local development environments, database migrations, and multi-language type generation via comprehensive CLI command guidance.

Supabase RLS Security Setup

Configures comprehensive Row Level Security policies for Supabase tables to ensure robust database-level access control.

Cross-Env PostgreSQL Extensions

Generates environment-agnostic PostgreSQL extension migrations using resilient DO block patterns for Nhost and CNPG.

Coder Convex Development

Streamlines self-hosted Convex backend development within Coder workspaces, handling queries, mutations, and authentication configuration.

Data Model Architect

Defines core system entities and relationships using a minimal, conceptual approach to establish a shared project vocabulary.

Mozilla BigQuery Query Writer

Writes cost-optimized, high-performance BigQuery queries for Mozilla telemetry and Firefox metrics.

SQL Optimization Patterns

Optimizes SQL queries and database schemas through advanced indexing strategies and execution plan analysis.

Supabase Postgres Best Practices

Optimizes Postgres database performance and security following Supabase's expert standards for schema design and query execution.

Backend Migrations Standard

Standardizes database schema evolutions by applying Agent OS backend migration patterns and best practices.

SQLite & Drizzle Database Management

Implements type-safe SQLite database workflows using LibSQL and Drizzle ORM for local, Turso, and Cloudflare D1 environments.

Firebase Firestore Specialist

Masters Firebase Firestore implementations with expert guidance on NoSQL data modeling, real-time synchronization, and advanced security rules.

Supabase Postgres Best Practices

Optimizes Postgres database performance and schema design using Supabase-vetted guidelines and performance rules.

Snowflake Platform Integration

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

Prisma ORM Expert

Optimizes Prisma ORM implementations through expert schema design, migration management, and high-performance query patterns.

NoSQL Design Expert

Architects high-scale distributed database systems using query-first modeling and single-table design patterns for Cassandra and DynamoDB.

Database Architect & Schema Designer

Guides architectural decisions for database selection, schema modeling, and performance optimization.

Data SQL & Schema Design

Optimizes SQL queries, designs scalable database schemas, and implements high-performance data modeling patterns.

Zod Firestore Type Safety

Implements end-to-end type safety for Firestore databases using Zod schemas and the withConverter API.

Database Reviewer Role

Evaluates database schemas, migrations, and SQL queries to ensure data safety, performance, and architectural integrity.

Snowflake Scripting for Windmill

Streamlines the creation, parameterization, and deployment of Snowflake SQL scripts within the Windmill automation platform.

SQLModel Task Schemas

Defines type-safe, production-ready SQLModel schemas for task management applications with integrated Better Auth support.

SQLModel Task & User Models

Generates robust, type-safe SQLModel schemas optimized for PostgreSQL and Better Auth integration.

Windmill DuckDB Script Writer

Generates and deploys optimized DuckDB scripts for the Windmill platform featuring external database and S3 integration.

Safe Supabase Migrator

Applies Supabase database migrations using a guarded, script-backed workflow to ensure safety and provide verification reports.