Database Management Claude 스킬

CRM Context Retrieval

Retrieves scoped CRM data and context from PostgreSQL to provide AI agents with precise business intelligence.

Supabase CLI

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

PostgreSQL Table Design

Architects high-performance, production-ready PostgreSQL schemas using modern best practices and advanced indexing patterns.

Supabase RLS Policy Setup

Configures production-ready Row Level Security policies for Supabase tables to ensure secure, role-based data access.

Supabase Prisma Database Management

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

Backend Queries

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

Atomic Transaction Manager for Supabase

Implements secure, atomic PostgreSQL transactions in Supabase using PL/pgSQL RPC functions to ensure data consistency.

WorldCrafter Database Setup

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

Backend Models

Standardizes the definition of database models, relationships, and constraints to ensure data integrity and consistent ORM implementation.

Backend Migrations

Manages database schema evolutions through reversible migrations, zero-downtime deployment strategies, and standardized version control practices.

Backend Queries

Optimizes database interactions by implementing secure, performant query patterns and preventing common pitfalls like SQL injection and N+1 overhead.

Backend Migrations

Manages database schema evolutions through versioned migration files that prioritize data integrity, reversible changes, and zero-downtime deployment strategies.

Backend Migrations

Manages database schema transitions with a focus on reversibility, data integrity, and zero-downtime deployment strategies.

SQL Code Formatter

Formats and polishes SQL queries according to Oracle Database 19 best practices for improved readability and consistency.

Database Schema Management

Manages PostgreSQL database schemas and Prisma ORM migrations within the ClaudeCode Sentiment Monitor project.

CHGIS Temporal Gazetteer

Queries the China Historical GIS Temporal Gazetteer API to retrieve and analyze historical Chinese placenames and administrative structures from 222 BCE to 1911 CE.

Database Migration Master

Executes complex database migrations and schema transformations across multiple ORMs with zero-downtime strategies.

Data Engineer

Architects and maintains robust data pipelines, analytics infrastructure, and integration workflows.

BigQuery ETL Core

Establishes foundational project structures, naming conventions, and privacy standards for managing large-scale BigQuery ETL workflows.

PostgreSQL Table Design

Designs optimized, production-grade PostgreSQL schemas following industry best practices and performance patterns.

AgentDB Advanced Features

Implements advanced vector database features including QUIC synchronization, hybrid search, and multi-node coordination for distributed AI systems.

PostgreSQL Table Design

Architects high-performance PostgreSQL schemas using industry-standard best practices for data integrity and scalability.

AgentDB Advanced Features

Implement high-performance distributed vector databases with sub-millisecond synchronization, hybrid search, and advanced distance metrics.

AgentDB Performance Optimization

Optimizes AgentDB vector database performance using quantization, HNSW indexing, and advanced caching strategies to reduce memory footprint and accelerate search speeds.

SQL Development

Writes, reviews, and optimizes performant SQL queries while applying PostgreSQL-specific best practices for schema design and performance tuning.

JGI Lakehouse Query

Facilitates querying and exploring the Joint Genome Institute (JGI) Dremio Lakehouse, including GOLD and IMG genomics databases.

Data Quality Test Generator

Generates comprehensive dbt test suites using modern 1.10+ syntax to ensure data integrity and structural consistency across analytical models.

Backend Migrations

Manages database schema changes through reversible, version-controlled migration files while ensuring zero-downtime deployment compatibility.

Database Migration & Schema Management

Automates and guides complex database migrations across multiple ORMs with a focus on zero-downtime and data integrity.

SQL Optimization Patterns

Optimizes SQL queries and database schemas using advanced indexing, execution plan analysis, and performance patterns.