Database Management Claudeスキル

Convex Backend Development

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

Prisma Database Patterns

Implements production-ready Prisma ORM patterns for database schema design, migrations, and high-performance queries.

Database Assistant

Expertly designs database schemas, optimizes complex SQL queries, and manages data migrations with industry-leading best practices.

Bknd Bulk Operations

Streamlines high-volume data operations in Bknd.io using optimized batch processing, chunking, and error handling strategies.

Databases & Architecture

Design and implement scalable database schemas, system architectures, and robust APIs for modern software applications.

Bknd Relationship Designer

Defines and manages complex data relationships, foreign keys, and associations within the Bknd.io ecosystem.

Supabase Setup & Management

Configures and secures Supabase backends including database schemas, RLS policies, authentication providers, and Edge Functions.

Shopify Database Best Practices

Optimizes Shopify app database operations using Prisma ORM with a focus on multi-tenant data isolation and high-performance query patterns.

SQL Optimization Patterns

Optimizes database performance through systematic query tuning, advanced indexing strategies, and detailed execution plan analysis.

Data Architecture Patterns

Implements a type-safe, single-source-of-truth data architecture using TypeScript and Zod for centralized project and personal information.

AgentDB Advanced Features

Powers distributed AI systems with low-latency QUIC synchronization, hybrid vector search, and multi-database management.

SQL Data Analysis Expert

Performs advanced SQL data analysis, query optimization, and complex transformations using modern database patterns.

SaaS Production Templates

Generates production-ready boilerplate for Supabase authentication, environment validation, and core Next.js layouts.

Database Stored Procedure Generator

Generates production-grade stored procedures, functions, and triggers across major SQL databases to streamline complex backend logic and data integrity.

Database Performance & Anti-Patterns

Identifies and remediates common database performance bottlenecks like N+1 queries, unbounded fetches, and connection pool issues.

Event Store Design & Implementation

Designs and implements robust, immutable event stores for event-sourced architectures and high-concurrency backend systems.

TikTok Supabase Data Sync

Synchronizes TikTok engagement data and readings from ClickHouse to Supabase to keep web content updated.

MCP Integration Core

Guides the integration of external databases and services into Claude Code using the Model Context Protocol (MCP).

SQL Performance Optimization Patterns

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

Database Deadlock Detector

Identifies, resolves, and prevents database deadlocks across PostgreSQL, MySQL, and MongoDB environments.

Database Optimization & Design Patterns

Optimizes database performance and scalability using advanced SQL, NoSQL, and Redis caching strategies.

Row-Level Security Patterns

Implements robust database row-level security policies for multi-tenant and user-scoped data architectures.

PostgreSQL Expert

Optimizes PostgreSQL performance, designs scalable architectures, and troubleshoots complex database internals with production-grade precision.

Slow Query Analysis & DB Tuning

Analyzes database slow query logs to identify performance bottlenecks and provide actionable indexing and optimization strategies.

Supabase Migrations & Schema Management

Manages Supabase database schemas and migrations through automated CLI commands and best-practice SQL patterns.

Domain-Driven Design Modeling

Models complex business logic using Domain-Driven Design patterns like Entities, Value Objects, and Aggregates.

Data Management Patterns

Provides standardized patterns for zero-downtime migrations, automated backups, data retention policies, and GDPR compliance workflows.

ClickHouse Analytics & Data Engineering

Optimizes ClickHouse database performance through high-performance schema design, advanced query patterns, and efficient data engineering practices.

SQL Guardrails

Enforces strict SQL standards and backend API patterns to prevent injection, data type mismatches, and contract violations.

Database Anti-Pattern Detection

Identifies and resolves common database performance bottlenecks and inefficient query patterns in modern ORMs.