Database Management Claude 技能

JUDO Query Optimization

Optimizes JUDO query performance by analyzing join strategies, caching mechanisms, and expression evaluation patterns.

WorldCrafter Database Setup

Generates Prisma models, database migrations, and Row-Level Security policies to establish a secure data foundation for world-building features.

JUDO Expression Syntax

Facilitates the implementation and debugging of JUDO expression metamodels and transfer object bindings.

Database Management

Configures and manages TinyDB document databases for efficient JSON-based data persistence in Python applications.

JUDO DAO Core Patterns

Guides the implementation of standardized data access patterns, payload processing, and entity lifecycle management within the JUDO framework.

Backend Queries

Writes secure, performant database queries and data fetching logic while implementing best practices like eager loading and parameterized inputs.

Supabase Prisma Database Management

Manages database schemas, migrations, and seed data using Prisma ORM integrated with Supabase PostgreSQL infrastructure.

Supabase SQLAlchemy Integration

Configures high-performance SQLAlchemy async patterns for Supabase, including Row Level Security (RLS) authentication and optimized connection pooling.

AsyncPG Database Detection

Scans Python and FastAPI projects to identify asyncpg imports, connection patterns, and query logic for migration to SQLAlchemy.

JUDO Query Translation

Translates logical JUDO expressions and models into structured SQL queries for efficient data retrieval.

Codebase & Schema Explorer

Accelerates codebase onboarding by automating the discovery of database schemas, API endpoints, and architectural patterns.

SQLAlchemy Conversion

Converts asyncpg database code to SQLAlchemy 2.0+ asynchronous patterns while preserving performance and transaction integrity.

JUDO Custom RDBMS Queries

Extends the JUDO DAO RDBMS query translation layer with custom mappers, translators, and join strategies.

JUDO Entity Mapping

Maps complex domain entities to transfer objects while handling unit conversion and instance graph relationships.

Prisma ORM Expert

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

JUDO Custom Expression Translators

Extends the JUDO Expression module by implementing custom translators for domain-specific logic and specialized calculations.

PostgreSQL Schema Design Expert

Architects high-performance PostgreSQL databases using industry-standard schema design, indexing strategies, and data integrity patterns.

Supabase Storage Manager

Manages file storage, bucket configurations, and secure access policies within the Supabase ecosystem.

Prisma ORM Development

Streamlines database development using Prisma 5+ with type-safe schema design, migration workflows, and optimized query patterns.

Prisma ORM Setup & Patterns

Configures and optimizes Prisma ORM for type-safe database access and streamlined schema management in Node.js applications.

Backend Queries

Writes efficient, secure database queries while preventing N+1 problems and SQL injection vulnerabilities.

Backend Models

Defines robust database models and schemas with precise ORM mappings, relationships, and data integrity constraints.

Spring Data JPA Best Practices

Implements high-performance Spring Data JPA repositories and entities using modern aggregate-centric patterns.

ClickHouse Analytics & I/O

Optimizes high-performance analytical workloads by implementing ClickHouse-specific database patterns and query best practices.

Supabase Expert

Manages Supabase database operations, security policies, and edge functions following project-specific standards and real-time state verification.

Ghost Database Migration Tool

Automates the process of creating, testing, and verifying database migrations within the Ghost CMS ecosystem.

PostgreSQL Database Development

Provides expert guidance on PostgreSQL schema design, Alembic migrations, SQLAlchemy patterns, and query optimization for high-performance database applications.

NestJS TypeORM Integration

Streamlines the setup, configuration, and refactoring of TypeORM within NestJS TypeScript projects for scalable database management.

SurrealDB for Dart

Integrates SurrealDB into Dart and Flutter applications with support for embedded databases, ORM features, and AI-powered vector search.

Supabase Database & Security Manager

Manages Supabase database instances, enforces PostgreSQL security best practices, and streamlines migration workflows for the Dashboard project.