Database

A reference skill providing PostgreSQL best practices covering query optimization, schema design, indexing strategies, Row Level Security, and connection pooling. Based on Supabase guidelines, it serves as a quick lookup for common patterns like composite indexes, cursor pagination, and queue processing.

A comprehensive reference guide for ClickHouse database development. Provides SQL patterns for table design (MergeTree engines), query optimization techniques, data insertion patterns, materialized views, and common analytics queries including time series analysis, funnel analysis, and cohort analysis.

This skill provides comprehensive PostgreSQL database design guidance covering data types, indexing strategies, constraints, partitioning, and schema design patterns. It includes detailed recommendations for handling JSONB, time-series data, update-heavy tables, and safe schema evolution practices.

This skill provides comprehensive guidance for executing database migrations across popular ORMs including Sequelize, TypeORM, and Prisma. It covers schema transformations, data migrations, rollback procedures, and zero-downtime deployment strategies with practical code examples.

This skill teaches SQL optimization techniques including query execution plan analysis (EXPLAIN), indexing strategies (B-Tree, GIN, GiST, BRIN), and common optimization patterns. It covers eliminating N+1 queries, cursor-based pagination, aggregate optimization, materialized views, and table partitioning for PostgreSQL and MySQL databases.

A comprehensive PostgreSQL database design guide that covers data types, indexing strategies, constraints, partitioning, JSONB usage, and performance optimization patterns. Includes AI agent definitions for database architecture and SQL expertise to help design scalable, maintainable database schemas.

A comprehensive migration toolkit that helps upgrade legacy applications to modern frameworks. Covers AngularJS to Angular migration with hybrid mode support, React class-to-hooks conversion, database schema migrations across ORMs (Sequelize, TypeORM, Prisma), and major dependency version upgrades with compatibility analysis and rollback procedures.

This skill provides comprehensive guidance for accessing the Human Metabolome Database (HMDB), a freely available resource containing detailed information about 220,000+ human metabolites. It covers web-based searches, spectral matching, data downloads, and common research workflows for metabolomics, biomarker discovery, and metabolite identification.

This skill provides AI assistants with deep knowledge about the Addax open-source ETL tool. It covers the project's architecture, plugin system for 20+ data sources (MySQL, PostgreSQL, MongoDB, Kafka, HDFS, etc.), job configuration format, data transformation capabilities, and development guidelines for building custom reader/writer plugins.

This skill provides detailed PostgreSQL performance optimization guidelines and best practices from Supabase. It covers query performance, connection pooling, Row-Level Security, schema design, and more with concrete SQL examples showing incorrect vs correct patterns.

A comprehensive reference skill for Supabase development covering the CLI workflow, database migrations, Row Level Security (RLS) policies, Edge Functions, and Storage configuration. It promotes local-first development with migrations in version control and includes CI/CD templates for automated deployment.

This skill helps prevent database-related coding errors by establishing a mandatory workflow where Claude reads schema files before writing any database code. It provides type generation commands for popular ORMs (Drizzle, Prisma, Supabase, SQLAlchemy) and includes verification checklists to ensure column names, types, and relationships are correct.

This skill provides comprehensive guidance for working with Azure Cosmos DB, covering partition key design, CRUD operations, consistency levels, batch operations, change feed processing, and cost optimization. It includes code examples for both TypeScript and Python SDKs.

A comprehensive reference skill for AWS DynamoDB development. Provides guidance on single-table design patterns, GSI strategies, TypeScript SDK v3 and Python boto3 code examples, batch operations, transactions, and local development setup with DynamoDB Local.

A comprehensive reference guide for AWS Aurora database development. Covers connection strategies (RDS Proxy, Data API, direct connections), serverless v2 configuration, Prisma ORM integration, connection pooling, migrations, monitoring, and security best practices including IAM authentication.

This skill should be used when user asks to "query Supabase", "list Supabase tables", "get Supabase schema", "search Supabase records", "check Supabase database", "Supabase auth", "Supabase authentication", "RLS policy", "row level security", "Supabase foreign key", "table relationships", "Supabase join", "Supabase filter", "Supabase pagination", or needs guidance on Supabase database patterns, auth flows, RLS policies, or query best practices.

This skill should be used when user asks to "query MongoDB", "show database collections", "get collection schema", "list MongoDB databases", "search records in MongoDB", or "check database indexes".