Database Management Claudeスキル

Blacklake OpenAPI Database Query

Queries and manages integrated connectors and API configurations within the v3_openapi database using structured SQL templates.

Database Tenant & Org Manager

Queries and manages tenant, organization, and factory information within the v3_user database using structured SQL execution.

Data Lake Architect

Designs scalable data lake and lakehouse architectures using optimized partitioning, storage tiers, and high-performance formats like Iceberg and Parquet.

SQLModel Task Data Modeling

Architects robust, type-safe, and asynchronous database schemas for task-based applications using SQLModel and PostgreSQL.

SQL Performance Optimizer

Optimizes SQL query performance by applying proven patterns for indexing, JOIN structures, and execution plan analysis.

DynamoDB Single-Table Designer

Architects high-performance, production-ready AWS DynamoDB schemas using single-table design principles to optimize scalability and cost.

AGI Memory System

Manages persistent AI memory through semantic, episodic, and working storage to enhance long-term context and knowledge recall.

DataFusion Query Advisor

Optimizes Apache DataFusion SQL queries and DataFrame operations through advanced performance analysis and best practices.

InterSystems IRIS DTL Transformations

Guides the development, testing, and implementation of Data Transformation Language (DTL) for InterSystems IRIS interoperability productions.

Rails Performance Optimization

Optimizes Ruby on Rails applications by identifying and resolving N+1 queries, implementing efficient caching, and managing background processing.

Rails Active Record Patterns

Optimizes Ruby on Rails data models using industry-standard ActiveRecord patterns for associations, validations, and high-performance queries.

Rust Parquet Optimization

Optimizes Parquet file operations in Rust to improve query performance, reduce storage costs, and prevent memory issues.

Drizzle ORM Workflow Manager

Manages Drizzle ORM and drizzle-kit workflows including migrations, schema generation, and specialized database reset flows.

AgentDB Performance Optimization

Optimizes AgentDB vector database performance through quantization, HNSW indexing, and advanced caching strategies to maximize search speed and minimize memory usage.

AgentDB Advanced Features

Implements high-performance vector search, distributed QUIC synchronization, and multi-database management for advanced AI systems.

Backend Queries

Constructs optimized and secure database queries using parameterized statements, eager loading, and efficient indexing strategies.

T-SQL Pro & Database Optimization

Writes high-performance, secure T-SQL code and optimizes SQL Server database schemas using industry best practices.

MySQL Database Skill

Executes safe SELECT queries against MySQL and MariaDB databases with built-in connection pooling and SQL injection prevention.

SQL Batching

Prevents D1/SQLite 'too many SQL variables' errors by automatically batching Drizzle ORM queries with dynamic arrays.

AgentDB Vector Search

Implements high-performance semantic vector search and document retrieval with sub-millisecond latency for intelligent RAG systems.

AgentDB Performance Optimization

Optimizes AgentDB vector database performance through quantization, HNSW indexing, and advanced caching strategies.

Database Schema Designer

Designs robust, production-ready SQL and NoSQL database schemas with built-in best practices for normalization, indexing, and scalability.

Backend Queries

Optimizes and secures database interactions by implementing efficient query patterns, preventing security vulnerabilities, and managing data performance.

Supabase RLS Policy Generator

Generates secure, production-ready Row-Level Security (RLS) policies for Supabase databases using multi-tenant and role-based access patterns.

Data Structure Selection Framework

Guides the selection of optimal data structures through a systematic analysis of performance requirements, operation frequencies, and memory constraints.

Snowflake AI & App Platform

Builds and deploys applications on Snowflake's AI Data Cloud using snow CLI, Cortex AI functions, and Native App patterns.

BigQuery CLI Integration

Facilitates seamless interaction with Google BigQuery via the bq command-line tool for data exploration and analysis.

Devops Database

Manages PostgreSQL database operations including Alembic migrations, backups, restorations, and pgvector extension management for development and production environments.

Prisma Expert

Architects and optimizes database schemas, migrations, and queries using the Prisma ORM.

CQRS Architectural Design

Implement Command Query Responsibility Segregation to optimize read and write operations in high-scale systems.