Database Management Claude 技能

East Node I/O

Provides a comprehensive suite of I/O functions for the East programming language, enabling seamless integration with databases, cloud storage, and file formats.

PostgreSQL Guide

Retrieves real-time, official PostgreSQL documentation for accurate SQL syntax, database configuration, and performance optimization.

PowerSync Local-First Sync

Builds offline-capable, local-first TypeScript applications with real-time SQLite-to-backend synchronization.

ER Diagram and Data Modeling

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

Zod Firestore Type Safety

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

Firebase Admin SDK for Next.js

Implements secure server-side Firebase Admin SDK patterns for Next.js 14+ to manage privileged operations and authentication.

Zod Firestore Type Safety

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

Firebase Next.js Integration Strategies

Implements robust Firebase integration patterns for Next.js 14+ App Router environments using dual SDK architectures.

Firestore Data Modeling Patterns

Provides expert guidance on structuring Firestore NoSQL databases for optimal performance, scalability, and cost-efficiency.

Database Schema Evaluator

Performs comprehensive multi-perspective audits of database architectures to optimize performance, integrity, and long-term scalability.

Firebase Next.js Integration Strategies

Streamlines Next.js 14+ App Router integration with Firebase using optimized dual-SDK architecture and server-side data fetching patterns.

Firestore Data Modeling Patterns

Optimizes NoSQL database structures using Firestore best practices for subcollections, data denormalization, and atomic operations.

Database Schema Evaluator

Analyzes database schemas using a multi-perspective expert panel to identify performance bottlenecks, normalization issues, and maintenance risks.

Firestore Security Rules Generator

Generates secure, production-ready Firestore security rules for user-scoped access and role-based control.

Data Engineering

Standardizes data pipeline design, ETL processes, and schema evolution using data-as-a-product principles.

Oxy Semantic Layer Builder

Builds and maintains structured Oxy semantic layer files to enable natural language data querying from database schemas.

ETL Pipeline Builder

Builds and extends robust, maintainable ETL pipelines using DLT for API connectors and spreadsheet ingestion.

PostgreSQL Explorer & Debugger

Explores, debugs, and manages PostgreSQL databases using AI-optimized JSON outputs and comprehensive schema discovery tools.

SQL Optimization Patterns

Optimizes database performance through systematic query analysis, advanced indexing strategies, and efficient execution patterns.

DataFusion & DeltaLake Integration

Provides comprehensive operational guidance for integrating Apache DataFusion with DeltaLake for high-performance data processing and query optimization.

Convex Component Authoring

Develops and packages self-contained, reusable Convex backend components with isolated database tables and type-safe exports.

Database Implementer

Generates robust database schemas, versioned migrations, and optimized data access layers for efficient application development.

Convex Component Authoring

Builds and publishes reusable, self-contained Convex backend components with isolated database tables and functions.

Backend Queries

Implements structured database queries and repository patterns using Prisma ORM to maintain a robust layered architecture.

Objectstar Legacy Migration

Analyzes, refactors, and migrates TIBCO Objectstar legacy mainframe applications to modern architectures and programming languages.

PostgreSQL Table Design

Architects production-grade PostgreSQL schemas using expert-level best practices for data integrity, performance, and scalability.

Supabase Infrastructure Manager

Manages Supabase projects including database migrations, Edge Functions deployment, and local development environments via the Supabase CLI.

Python Data Engineering

Builds production-grade data pipelines and dimensional models using SQLAlchemy 2.0 and modern warehouse architectures.

Metadata Manager

Streamlines the creation and management of BigQuery table schemas, metadata configurations, and Airflow DAG schedules following Mozilla ETL conventions.

SQL Optimization Patterns

Optimizes SQL query performance through systematic execution plan analysis, advanced indexing strategies, and proven query restructuring patterns.