#SkillRepo stars

1. 1Clickhouse Ioaffaan-m/ECCClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.294k
2. 2Clickhouse Ioaffaan-m/ECC고성능 분석 워크로드를 위한 ClickHouse 데이터베이스 패턴, 쿼리 최적화, 분석 및 데이터 엔지니어링 모범 사례.294k
3. 3Database Migrationsaffaan-m/ECCDatabase migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Django, TypeORM, golang-migrate). Use when planning or implementing database schema changes.294k
4. 4Database Migrationsaffaan-m/ECCBuenas prácticas de migración de base de datos para cambios de esquema, migraciones de datos, rollbacks y despliegues de tiempo cero en PostgreSQL, MySQL y ORMs comunes (Prisma, Drizzle, Kysely, Django, TypeORM, golang-migrate).294k
5. 5Database Migrationsaffaan-m/ECCPostgreSQL、MySQL、一般的なORM（Prisma、Drizzle、Kysely、Django、TypeORM、golang-migrate）全体のスキーマ変更、データマイグレーション、ロールバック、ゼロダウンタイムデプロイメントのためのデータベースマイグレーションベストプラクティス。294k
6. 6Database Migrationsaffaan-m/ECCŞema değişiklikleri, veri migration'ları, rollback'ler ve PostgreSQL, MySQL ve yaygın ORM'ler (Prisma, Drizzle, Django, TypeORM, golang-migrate) arasında sıfır kesinti deployment'ları için veritabanı migration en iyi uygulamaları.294k
7. 7Postgres Patternsaffaan-m/ECCPostgreSQL database patterns for query optimization, schema design, indexing, and security. Quick reference for common patterns, index types, data types, and anti-pattern detection. Based on Supabase best practices.294k
8. 8Postgres Patternsaffaan-m/ECCPatrones de base de datos PostgreSQL para optimización de consultas, diseño de esquemas, indexación y seguridad. Basado en las buenas prácticas de Supabase.294k
9. 9Postgres Patternsaffaan-m/ECCPostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.294k
10. 10Postgres Patternsaffaan-m/ECC쿼리 최적화, 스키마 설계, 인덱싱, 보안을 위한 PostgreSQL 데이터베이스 패턴. Supabase 모범 사례 기반.294k
11. 11Redis Patternsaffaan-m/ECCRedisデータ構造パターン、キャッシング戦略、分散ロック、レート制限、Pub/Sub、本番アプリケーション用コネクション管理。294k
12. 12Scientific Db Uspto Databaseaffaan-m/ECC公式記録の検索、PatentSearch クエリ、TSDR チェック、譲渡データ、および再現可能な IP 調査ログのための USPTO 特許・商標データワークフロー。294k
13. 13Alloydb Basicsgoogle/skillsManages clusters, instances, and backups for AlloyDB for PostgreSQL, and integrates with AlloyDB Model Context Protocol (MCP) tools for automated database operations. Use when creating, configuring, or administering AlloyDB databases. Do NOT use for general PostgreSQL instances (e.g. Cloud SQL) or other GCP databases.22k
14. 14Bigquery Basicsgoogle/skillsManages datasets, tables, and jobs in BigQuery. Use when you need to interact with BigQuery, run SQL queries, manage BigQuery resources (datasets, tables, views), or perform basic data ingestion and analysis.22k
15. 15Cloud SQL Basicsgoogle/skillsThis file generates or explains Cloud SQL resources. Use this file when the user asks to create a Cloud SQL instance or database for MySQL, PostgreSQL, or SQL Server. Cloud SQL manages third-party MySQL, PostgreSQL, and SQL Server instances as resources in Cloud SQL. For example, when Cloud SQL creates an open-source MySQL instance, the resulting resource is a Cloud SQL for MySQL instance that Google Cloud manages. Cloud SQL handles backups, high availability, and secure connectivity for relational database workloads.22k
16. 16SQL Queriesphuryn/pm-skillsGenerate SQL queries from natural language descriptions. Supports BigQuery, PostgreSQL, MySQL, and other dialects. Reads database schemas from uploaded diagrams or documentation. Use when writing SQL, building data reports, exploring databases, or translating business questions into queries.28k
17. 17Postgres ProJeffallan/claude-skillsUse when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features. Invoke for EXPLAIN analysis, JSONB operations, extension usage, VACUUM tuning, performance monitoring.12k
18. 18SQL ProJeffallan/claude-skillsOptimizes SQL queries, designs database schemas, and troubleshoots performance issues. Use when a user asks why their query is slow, needs help writing complex joins or aggregations, mentions database performance issues, or wants to design or migrate a schema. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis, covering index creation, recursive queries, EXPLAIN/ANALYZE interpretation, before/after query benchmarking, or migrating queries between database dialects (PostgreSQL, MySQL, SQL Server, Oracle).12k
19. 19Supabase Postgres Best Practicessupabase/agent-skillsPostgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill BEFORE writing or changing anything that lives in a Postgres database: creating or altering tables and columns (including choosing column types), schema design, migrations and declarative schema files, RLS policies and the tests that verify them, indexes, triggers, database functions, queues and scheduled jobs (pg_cron, pgmq), vector/semantic search (pgvector), and restoring dumps (pg_restore) or importing data. Also load it when diagnosing slow queries, high CPU, timeouts, EXPLAIN plans, connection 3k
20. 20Claimable Postgresneondatabase/mcp-server-neonProvision instant temporary Postgres databases via Claimable Postgres by Neon (neon.new) with no login, signup, or credit card. Supports REST API, CLI, and SDK. Use when users ask for a quick Postgres environment, a throwaway DATABASE_URL for prototyping/tests, or "just give me a DB now". Triggers include: "quick postgres", "temporary postgres", "no signup database", "no credit card database", "instant DATABASE_URL", "npx neon-new", "neon.new", "neon.new API", "claimable postgres API".659
21. 21Wx Favorites Reportzhuyansen/wx-favorites-report微信收藏可视化：从加密的微信本地数据库端到端解密、解析，生成交互式 HTML 可视化报告。 触发词：/wx-favorites-report、微信收藏可视化、收藏报告、收藏分析 支持输入：加密/解密后的 Favorite.db（SQLite）或 CSV/JSON 导出文件642
22. 22Mssqlsanjay3290/ai-skillsExecute read-only SQL queries against multiple Microsoft SQL Server databases. Use when: (1) querying MSSQL/SQL Server databases, (2) exploring database schemas/tables, (3) running SELECT queries for data analysis, (4) checking database contents. Supports multiple database connections with descriptions for intelligent auto-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.448
23. 23Mysqlsanjay3290/ai-skillsExecute read-only SQL queries against multiple MySQL databases. Use when: (1) querying MySQL databases, (2) exploring database schemas/tables, (3) running SELECT queries for data analysis, (4) checking database contents. Supports multiple database connections with descriptions for intelligent auto-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.448
24. 24PostgreSQL Queriessanjay3290/ai-skillsExecute safe read-only SQL queries against PostgreSQL databases. Analyze and explore your database with Claude.448
25. 25Clickhouse Best PracticesClickHouse/agent-skillsMUST USE when reviewing ClickHouse schemas, queries, or configurations. Contains 31 rules that MUST be checked before providing recommendations. Always read relevant rule files and cite specific rules in responses.562
26. 26Attach Dbduckdb/duckdb-skillsAttach a DuckDB database file for use with /duckdb-skills:query. Explores the schema (tables, columns, row counts) and writes a SQL state file so subsequent queries can restore this session automatically via duckdb -init.613
27. 27Queryduckdb/duckdb-skillsRun SQL queries against the attached DuckDB database or ad-hoc against files. Accepts raw SQL or natural language questions. Uses DuckDB Friendly SQL idioms.613
28. 28Better Auth Best Practicesbetter-auth/skillsConfigure Better Auth server and client, set up database adapters, manage sessions, add plugins, and handle environment variables. Use when users mention Better Auth, betterauth, auth.ts, or need to set up TypeScript authentication with email/password, OAuth, or plugin configuration.227
29. 29Redis Coreredis/agent-skillsCore Redis modeling guidance — choose the right data structure (String, Hash, List, Set, Sorted Set, JSON, Stream, Vector Set) and use consistent colon-separated key names. Use when designing a Redis data model, caching objects, deciding between Hash and JSON, building counters, leaderboards, membership sets, or session stores, or when reviewing/cleaning up Redis key naming.171
30. 30Neon Postgresneondatabase/agent-skillsGuides and best practices for working with Lakebase Postgres on Neon: connections, pooled vs direct, schema migrations, branching, autoscaling, scale-to-zero, instant restore, read replicas, IP allow lists, logical replication, and Lakebase Search. Use when the work is an existing DATABASE_URL, SQL, schema, inspect, or search. New backends, Auth, files, Functions, and LLM calls go to the parent `neon` skill. Live queries, reactive UIs, and realtime data go to `neon-realtime`. Also use for "@neondatabase/serverless", "@neon/neon-js", "neon inspect db", "semantic search", "vector search", "full-108
31. 31Neon Postgres Egress Optimizerneondatabase/agent-skillsDiagnose and fix excessive Postgres egress (network data transfer) in a codebase. Use when a user mentions high database bills, unexpected data transfer costs, network transfer charges, egress spikes, "why is my Neon bill so high", "database costs jumped", SELECT * optimization, query overfetching, reduce Neon costs, optimize database usage, or wants to reduce data sent from their database to their application. Also use when reviewing query patterns for cost efficiency, even if the user doesn't explicitly mention egress or data transfer.108
32. 32Exploreexmergo/dexUse this whenever you need to know what is actually in a database, warehouse, or DuckDB file before you trust it: inventory, column profiles, PII detection, grain and data-quality problems, verified joins, ER diagrams, ad-hoc SQL probes, segmentation, and the semantic layer a repo declares (dbt, Ossie, SLayer, or Cube). Trigger it on an unmet precondition, not on phrasing: if you are about to write or fix SQL against tables whose columns, types, grain, or join keys you have not verified in this session, use this FIRST. That includes dbt work (building a model, fixing one, debugging wrong numbe107
33. 33Slr Prismakeemanxp/slr-prismaGuide users through writing a systematic literature review (SLR) following the PRISMA 2020 framework. Use this skill whenever the user mentions 'systematic review', 'systematic literature review', 'SLR', 'PRISMA', 'PRISMA 2020', 'PRISMA flow diagram', 'PRISMA checklist', or asks for help writing, structuring, or auditing a literature review that follows reporting guidelines. Also trigger when the user asks about inclusion/exclusion criteria for a review, search strategies for databases like Scopus/WoS/PubMed, study selection processes, risk of bias assessment, or narrative synthesis for a revi116
34. 34Netlify Databasenetlify/context-and-toolsZero-config Postgres for Netlify apps via @netlify/database — querying data from Functions/Edge Functions, writing schema migrations, setting up Drizzle ORM, local dev with netlify dev, database branches for deploy previews, and migrating an existing Postgres project onto Netlify. Use when adding a database, building a contact form or CRUD API, writing SQL migrations, wiring up Drizzle, running netlify database commands, testing with a local Postgres, or switching from Neon/Supabase/RDS to Netlify Database.49
35. 35Database SentinelFarenhytee/database-sentinelMulti-backend database security auditor. Audits Supabase, Firebase (Firestore/RTDB/Storage/Functions/Remote Config), MongoDB (self-hosted + Atlas), self-hosted PostgreSQL, and self-hosted MySQL for RLS/rules misconfigurations, exposed credentials, auth bypasses, MongoBleed (CVE-2025-14847), pgBouncer CVE-2025-12819, mysql_native_password drift, ghost auth, and storage exposures. Use this skill whenever the user mentions database security, RLS or rule audits, security review, penetration testing a vibe-coded app, checking if their DB is exposed, hardening a backend, fixing security rules, or au51
36. 36Dolphindb Skillhugo2046/dolphindb_skillDolphinDB/DolphinScript 的数据库、SQL、流计算、回测与排障技能。用户提到 DolphinDB，或仓库/代码出现 dfs://、createPartitionedTable、context by、streamTable、subscribeTable、createTimeSeriesEngine、DStream::、Backtest:: 等专有线索时调用；已有 DolphinDB 上下文时，即使本轮只说“分区表”“实时 K 线”“回测报错”也要使用。用于按目标 Server/插件版本核对官方 API、选择 OLAP/TSDB/PKEY/IOT，并生成可验证的代码与方案。明确只涉及其他技术栈且无 DolphinDB 上下文时不调用。36
37. 37App Platform Routerdigitalocean-labs/do-app-platform-skillsRoutes DigitalOcean App Platform tasks to specialized sub-skills. Use when working with App Platform deployments, migrations, database configuration, networking, or troubleshooting.38
38. 38Tinybirdtinybirdco/tinybird-agent-skillsTinybird file formats, SQL rules, optimization patterns, and best practices for datasources, pipes, endpoints, and materialized views.22
39. 39Cognitive Toolkitglebis/claude-cognitive-toolkitEvidence-based CBT and DBT intervention skills — guided thought records, opposite action, DEAR MAN roleplay, crisis skills with optional HRV biofeedback. Configurable therapeutic pushback. Triggers on "/cbt", "/dbt", "/thought-record", "/record", "/opposite", "/opposite-action", "I need to work through something", "help me with a thought", "cognitive distortion", "I'm spiraling", "can we do a thought record".24
40. 40Paradedb Skillparadedb/agent-skillsExpert guidance on ParadeDB text and vector search, hybrid search (BM25 + semantic), filters, facets, joins, and aggregations in Postgres. Use when writing ParadeDB queries, creating ParadeDB indexes, indexing vectors, configuring tokenizers, or implementing Elasticsearch-quality search in Postgres.11
41. 41Genpark Lead Harvesteralphaparkinc/genpark-lead-harvesterHigh-precision social intent monitoring and lead acquisition engine. Scans social platforms for users experiencing high e-commerce friction (overpricing, refund failures, subscription traps) and aggregates them into a local actionable database for GenPark conversion.9
42. 42Gospecsingchia/gospecGo 后端 SDLC 全流程中文规范。覆盖 Bounded Context 切分、Kratos 风格分层（cmd/server/service/biz/data/model）、API 设计、数据模型（MySQL / Redis / ClickHouse / InfluxDB）、测试、CI/CD、日志指标追踪 SLO、认证密钥安全、部署与事故、数据库 migration、PRD/RFC/ADR/HLD 文档。框架中性——Web 框架可选 Kratos / gin / Hertz / chi / echo，规范只约束分层和依赖方向。写或审查 Go 代码时按需加载。Go backend SDLC spec — framework-neutral, load on demand for coding/design/testing/ops/docs.7
43. 43DBT Semantic Layer Developerkeithbinkly/dbt-semantic-layerProvides expert-level assistance with dbt Semantic Layer, MetricFlow, semantic models, metrics, dimensions, entities, measures, and BI tool integrations. Use this skill when building semantic models, creating metrics (simple, ratio, cumulative, derived, conversion), debugging validation errors, or integrating with BI tools. Extracted from official dbt documentation and optimized for data practitioners.7
44. 44Time Ledgercruisekkk/time-ledgerNatural-language time tracking — the user says what they did in plain language, you parse it into Activity + Minutes + Date and write it to their Notion database; anything uncertain you mark To-confirm and BATCH-ASK rather than fabricate. Use when the user reports time spent (e.g. "read papers for two hours", "hit the gym for an hour", "coded all morning"), says log it / log my time / tidy up my time ledger / time ledger, or asks where their time went.7
45. 45Xuanxue Databaseyanouyuan-bit/xuanxue-database-skill引导用户通过对话从零搭建个人玄学数据库——「命盘与结论库 / 应事与回测库 / 方法与资料库」三库体系，支持 Notion 一键建库与本地 Markdown 双模式，覆盖八字命理、六爻占卜、紫微斗数。当用户提到想搭建或整理命理资料库、记录命例/卦例、建立应事回测体系、验证断语准确率、系统化管理玄学学习笔记，或说「搭建玄学数据库」「整理我的命例」「怎么记录卦例」「想系统地学命理/追踪应验」时，使用本 skill——即使用户没有明确说出「数据库」三个字。5
46. 46Analyzing Database Indexesjeremylongshore/claude-code-plugins-plus-skillsThis skill uses the database-index-advisor plugin to analyze query patterns and recommend optimal database indexes. It identifies missing indexes to improve query performance and unused indexes that can be removed to save storage and improve write performance. Use this skill when the user asks to "analyze database indexes", "optimize slow queries", "find missing indexes", "remove unused indexes", or requests help with "database index optimization". The plugin analyzes database workloads, detects potential indexing issues, and provides actionable recommendations for indexing strategies.
47. 47Analyzing Query Performancejeremylongshore/claude-code-plugins-plus-skillsThis skill enables Claude to analyze and optimize database query performance. It activates when the user discusses query performance issues, provides an EXPLAIN plan, or asks for optimization recommendations. The skill leverages the query-performance-analyzer plugin to interpret EXPLAIN plans, identify performance bottlenecks (e.g., slow queries, missing indexes), and suggest specific optimization strategies. It is useful for improving database query execution speed and resource utilization.
48. 48Archiving Databasesjeremylongshore/claude-code-plugins-plus-skillsThis skill automates database archival processes. It helps reduce primary database size by moving historical records to archive tables or cold storage solutions like S3, Azure Blob, or GCS. The plugin supports PostgreSQL and MySQL, implementing automated retention policies, compression, compliance tracking, and zero-downtime migration. Use this when the user mentions "database archival", "archive old database records", "retention policies", "cold storage", or "reduce database size." It is particularly useful for handling requests related to data lifecycle management and compliance requirements