Sql

postgres-patterns is a practical PostgreSQL quick-reference skill for query optimization, schema design, indexing, Row Level Security, and connection pooling. It helps Database Engineering workflows make faster, more reliable decisions using compact best practices rather than a generic prompt.

kotlin-exposed-patterns is a practical guide for Kotlin database engineering with JetBrains Exposed. It covers DSL queries, DAO pattern, newSuspendedTransaction, HikariCP, Flyway migrations, and repository boundaries for maintainable data access.

jpa-patterns is a practical JPA/Hibernate guide for Spring Boot backend development. It covers entity design, relationships, query tuning, transactions, auditing, pagination, and pooling to help reduce ORM mistakes and improve persistence performance.

The database-migrations skill helps backend teams plan safe schema changes, data backfills, rollbacks, and zero-downtime deploys for PostgreSQL, MySQL, and common ORMs. Use it for production-safe database-migrations guide work when you need clear steps, fewer locks, and reversible changes.

clickhouse-io is a ClickHouse-focused skill for schema design, analytical SQL, ingestion patterns, and performance tuning. Use it to guide MergeTree choices, partitioning, materialized views, and workload-specific query optimization.

data-analyst is a minimal GitHub skill that guides agents toward SQL, pandas, and basic statistical analysis for data exploration. Best for users who want code-backed queries, transformations, and interpretations from a single SKILL.md prompt layer.

sql-optimization-patterns helps diagnose slow SQL with EXPLAIN analysis, indexing strategy, join tuning, pagination fixes, and practical query rewrite guidance for database engineering teams.

dbt-transformation-patterns helps agents structure dbt projects with staging, intermediate, and marts layers, plus testing, documentation, and incremental model guidance. Use it to plan installs, scaffold new repos, or refactor SQL into cleaner analytics engineering patterns for Database Engineering teams.

spark-optimization is a practical guide to diagnosing slow Apache Spark jobs with partitioning, shuffle, skew, caching, and memory tuning. Use it to install the skill from wshobson/agents, read SKILL.md, and apply evidence-based fixes from Spark UI symptoms, cluster settings, and query patterns.

postgresql-table-design helps agents design or review PostgreSQL schemas with practical rules for keys, normalization, data types, constraints, foreign key indexes, and PostgreSQL-specific gotchas.

database-migration helps plan and generate schema and data migrations across ORM and SQL workflows, with rollback safety, phased rollouts, and zero-downtime guidance for production Database Engineering teams.

dummy-dataset generates realistic test data in CSV, JSON, SQL, or Python script form. It helps with mock datasets, demos, database seeding, QA, and data cleaning by letting you define columns, row counts, and constraints for believable sample records.

The sql-queries skill turns business questions and rough analytics goals into optimized SQL for BigQuery, PostgreSQL, MySQL, and other dialects. It reads schema context, clarifies filters and aggregations, and helps with sql-queries for Data Analysis, reporting, and exploration.

azure-resource-manager-sql-dotnet helps backend developers provision and manage Azure SQL resources from .NET with Azure Resource Manager. Use it for servers, databases, elastic pools, firewall rules, and failover groups. It is for management-plane tasks, not SQL queries or data access; for that, use Microsoft.Data.SqlClient.

supabase-postgres-best-practices is a Supabase Postgres optimization skill for query tuning, indexing, schema design, RLS performance, locking, and connection management.

database-schema-designer helps developers and database engineers design production-ready SQL or NoSQL schemas with normalization, indexing, constraints, and migration planning. Includes trigger phrases, a schema design checklist, and a migration template for practical schema generation and review.

database-schema helps agents read the database contract before writing queries, migrations, or model code. It reduces wrong column names, missing fields, and type mismatches by checking schema files and generated types first. Use this database-schema guide for safer Database Engineering workflows.

The query skill runs DuckDB queries against an attached database or directly against files. It accepts SQL or natural-language questions, supports session and ad-hoc modes, and is useful for Data Analysis, quick checks, and iterative query work with DuckDB Friendly SQL.

attach-db helps you attach a DuckDB database file for immediate querying with /duckdb-skills:query. It validates the file, checks DuckDB is installed, inspects schema details, and writes shared state so later queries can restore automatically with duckdb -init. Built for Database Engineering workflows that need a reliable attach-db guide.

clickhouse-best-practices is a ClickHouse best practices skill for Database Engineering. It guides schema design, query tuning, insert strategy, and agent connectivity with rule-based recommendations, making clickhouse-best-practices usage easier to trigger, review, and cite in ClickHouse workflows.

clickhouse-architecture-advisor helps design ClickHouse workloads with workload-aware decisions for ingestion, partitioning, joins, dictionaries, upserts, and pre-aggregation. It is especially useful for Backend Development, observability, SIEM, product analytics, IoT telemetry, and financial pipelines. The skill labels guidance as official, derived, or field.

The postgres-nio skill helps you use PostgreSQL from Swift with async/await, connection pooling, prepared statements, and type-safe queries. It is a strong fit for Backend Development teams building Swift services that need practical postgres-nio usage, not generic SQL theory.

neon-postgres-egress-optimizer helps diagnose and reduce Postgres egress by using pg_stat_statements to find overfetching queries, validate measurement windows, and guide app-side fixes such as narrower selects, pagination, and ORM query changes.

claimable-postgres helps you provision a temporary Neon Postgres database fast with no signup. Use REST API, CLI, SDK, or Vite plugin to get a DATABASE_URL for local development, demos, tests, and short-lived review environments. Databases expire after 72 hours unless claimed.