Search
PostgreSQL · SQL
Skills
Sort:BestMost starsTrending todayTrending this weekTrending this monthNewestRecently updatedName
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 1 | Gives the agent Postgres rules to consult before writing or changing tables, queries, indexes, RLS policies or migrations, and when diagnosing slow queries. | supabase/ | 2.7k | 24 repos | ~808 | Automated safety check: Pass | MIT | 5 days ago |
| 2 | A skill your agent uses whenever code will build, return, fetch, or execute SQL that runs against a user's real Postgres database — even when the request reads like an ordinary feature or bug fix… | supabase/ | 111k | — | ~4.2k | Automated safety check: Pass | Apache-2.0 | today |
| 3 | 3.Sql2er A skill your agent uses when the user wants a Chen-model ER diagram from SQL CREATE TABLE statements or DBML, wants to rearrange or clean up an existing sql2er state, wants a skeleton-only overview… | ystemsrx/ | 188 | 1 repo | ~1.1k | Automated safety check: Pass | AGPL-3.0 | 7 days ago |
| 4 | Guides classifying, gap-analyzing and scaffolding support for a new SQL database in pREST, from Postgres-compatible variants to entirely new dialects. | prest/ | 4.6k | — | ~1.6k | Automated safety check: Pass | MIT | today |
| 5 | A skill your agent uses to analyze an existing PostgreSQL database and identify which tables should be converted to Timescale/TimescaleDB hypertables. | timescale/ | 1.9k | 1 repo | ~2.6k | Automated safety check: Pass | Apache-2.0 | today |
| 6 | 6.Chdb SQL A skill your agent uses when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse… | vemetric/ | 394 | 1 repo | ~1.2k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 7 | Add/modify/debug Materialize perf benchmark scenarios. An agent skill from MaterializeInc/materialize. | MaterializeInc/ | 6.4k | — | ~2.8k | Automated safety check: Pass | Unknown | today |
| 8 | Explore an existing PostgreSQL database before answering questions about its data or writing SQL. | timescale/ | 1.9k | — | ~1.1k | Automated safety check: Pass | Apache-2.0 | today |
| 9 | PostgreSQL database documentation - SQL queries, database design, administration, performance tuning, and advanced features. Use when working with… | 2025Emma/ | 23k | 1 repo | ~19k | Automated safety check: Pass | MIT | 9 mo ago |
| 10 | 10.Squix Run SQL queries across databases (Postgres, MySQL, SQLite, etc.) via the squix CLI. | eduardofuncao/ | 273 | — | ~784 | Automated safety check: Pass | MIT | 15 days ago |
| 11 | Inspects, queries and carefully modifies the MoviePilot SQLite or PostgreSQL database through a bundled script that reads connection settings itself, without needing the password in the prompt. | jxxghp/ | 12k | — | ~7.3k | Automated safety check: Pass | GPL-3.0 | today |
| 12 | SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, SQL Server | rmyndharis/ | 1.7k | 3 repos | ~577 | Automated safety check: Notes | MIT | 7 days ago |
| 13 | 13.Pg Data Generate safe, read-only PostgreSQL queries from natural language. | tyrchen/ | 236 | — | ~2.8k | Automated safety check: Pass | No licence | 6 mo ago |
| 14 | 14.Diesel Guard Lints Diesel and SQLx Postgres migrations for unsafe schema changes that lock tables or cause downtime, and authors custom Rhai checks. | ayarotsky/ | 121 | — | ~3.1k | Automated safety check: Pass | MIT | 9 days ago |
| 15 | 15.Npgsqlrest Build and modify REST APIs with NpgsqlRest — exposing PostgreSQL as HTTP endpoints from two sources (database functions/procedures/tables/views, and plain .sql files), driven by SQL comment… | NpgsqlRest/ | 132 | — | ~7k | Automated safety check: Notes | MIT | 5 days ago |
| 16 | Reviews schema design, SQL queries, ORM patterns. An agent skill from DanielPodolsky/ownyourcode. | DanielPodolsky/ | 290 | 1 repo | ~1.6k | Automated safety check: Pass | MIT | 3 mo ago |
| 17 | Sets Rust conventions for the Windmill backend: error types, SQLx queries, JSON handling, async rules, module layout and rust-analyzer navigation. | windmill-labs/ | 18k | — | ~869 | Automated safety check: Pass | Unknown | today |
| 18 | Comprehensive guide for Go database access — parameterized queries, struct scanning, NULLable columns, transactions, isolation levels, SELECT FOR UPDATE, connection pool, batch processing, context… | unxed/ | 241 | 2 repos | ~2.9k | Automated safety check: Pass | MIT | today |
| 19 | Extend parallel-workload stress framework: random SQL concurrently to catch panics + unexpected errors (not perf — see mz-benchmark). | MaterializeInc/ | 6.4k | — | ~1.9k | Automated safety check: Pass | Unknown | today |
| 20 | Query indexed Tempo chain data via tidx HTTP API and CLI. An agent skill from tempoxyz/tidx. | tempoxyz/ | 107 | — | ~3.1k | Automated safety check: Pass | MIT | today |
| 21 | 21.Postgres Execute read-only SQL queries against multiple PostgreSQL databases. | sanjay3290/ | 431 | 1 repo | ~975 | Automated safety check: Pass | Apache-2.0 | 27 days ago |
| 22 | Analyze PostgreSQL git commit history between two commit ids and, when valuable DBA/application-developer changes exist, write a Chinese Markdown article for WeChat/公众号 readers with examples checked… | digoal/ | 8.6k | — | ~2.3k | Automated safety check: Pass | GPL-2.0 | 10 days ago |
| 23 | 23.Gen Ctx YAML Generate .ctx.yaml table group context files for NL2SQL optimization. | flyxl/ | 114 | — | ~661 | Automated safety check: Pass | GPL-3.0 | 8 days ago |
| 24 | 24.Gaik Toolkit GAIK toolkit overview and reference. An agent skill from GAIK-project/gaik-toolkit. | GAIK-project/ | 100 | — | ~5.7k | Automated safety check: Pass | MIT | today |
| 25 | Answer analytical, KPI, metric, trend, cohort, and business-performance questions through a Sidemantic semantic layer. | sidequery/ | 129 | — | ~982 | Automated safety check: Pass | AGPL-3.0 | today |
| 26 | Safely regenerates Windmill's SQLx offline query cache after a SQL query changes in Rust, with a mandatory backup step and worktree-specific database checks. | windmill-labs/ | 18k | — | ~1.7k | Automated safety check: Pass | Unknown | today |
| 27 | 27.Srtd CLI This skill should be used when the user mentions "srtd", "sql templates", "migrations-templates", "live reload sql", "supabase functions", when working with files in supabase/migrations-templates/… | t1mmen/ | 105 | — | ~360 | Automated safety check: Pass | MIT | 1 mo ago |
| 28 | 28.Faasjs Pg A skill your agent uses when working with @faasjs/pg or PostgreSQL in FaasJS: Tables declaration merging, QueryBuilder, select aliases, parameterized sql expressions, raw SQL, numeric/decimal/bigint… | faasjs/ | 121 | — | ~718 | Automated safety check: Pass | MIT | 1 mo ago |
| 29 | Analyze and optimize a Console/catalog SQL query in user space — diagnose its plan on real relations, then measure candidate rewrites with a faithful synthetic-fleet sweep. | MaterializeInc/ | 6.4k | — | ~2.1k | Automated safety check: Pass | Unknown | today |
| 30 | 30.DB Context Complete knowledge of the optimizer PostgreSQL database: 57 ingestion tables, schema, relationships, live row counts, query patterns, and conventions. | SilvioBaratto/ | 176 | — | ~6.4k | Automated safety check: Notes | Unknown | today |
| 31 | 31.Drizzle Orm Type-safe SQL ORM for TypeScript with zero runtime overhead. An agent skill from growupanand/ConvoForm. | growupanand/ | 101 | 1 repo | ~2.7k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 32 | 数据库优化专家入口。用于 Codex CLI 的 $expert-database 调用. An agent skill from ReJeCtAll/ExpertTeam-Codex. | ReJeCtAll/ | 113 | — | ~692 | Automated safety check: Pass | MIT | 3 mo ago |
| 33 | Debug SQL execution time via distributed tracing (OpenTelemetry / Tempo). | MaterializeInc/ | 6.4k | — | ~1.8k | Automated safety check: Pass | Unknown | today |
| 34 | 34.Postgres A skill your agent uses for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS, TimescaleDB), search, and migrations. | timescale/ | 1.9k | — | ~941 | Automated safety check: Pass | Apache-2.0 | today |
| 35 | CloudBase PostgreSQL access-pattern and slow-query quality guidance. | TencentCloudBase/ | 1.1k | 1 repo | ~1.3k | Automated safety check: Pass | MIT | today |
| 36 | Runs read-only SQL queries and schema exploration against PostgreSQL databases declared in .env, chosen by label or index, with writes blocked unless a connection allows them. | evolution-foundation/ | 545 | — | ~1.8k | Automated safety check: Notes | Unknown | 4 mo ago |
| 37 | 37.Ron Database Manage PostgreSQL migrations, typed SQL queries, generated Rust bindings, and database authorization in Rust on Nails applications. | bionic-gpt/ | 2.4k | — | ~721 | Automated safety check: Pass | Apache-2.0 | yesterday |
| 38 | Tunes and administers PostgreSQL: EXPLAIN-driven query tuning, index choice, JSONB, extensions, streaming or logical replication, VACUUM and pg_stat monitoring. | Jeffallan/ | 12k | — | ~1.5k | Automated safety check: Pass | MIT | 4 days ago |
| 39 | 39.SQL Pro Optimizes SQL queries and designs schemas using CTEs, window functions, covering indexes and EXPLAIN ANALYZE, with notes on dialect differences between major databases. | Jeffallan/ | 12k | — | ~1.3k | Automated safety check: Pass | MIT | 4 days ago |
| 40 | Wavelet 项目专用:当新增或修改数据库表结构、索引、初始化数据、系统配置 seed、模板 seed、默认管理员、goose SQL 迁移、internal/infra/persistence/migrator、ClickHouse 分析库 DDL 或数据库升级流程时必须使用。本技能指导在 internal/infra/persistence/migrator/goose 下编写… | Rain-kl/ | 288 | — | ~1.3k | Automated safety check: Pass | Apache-2.0 | today |
| 41 | 41.DB Migrate Миграция схемы базы данных: SQLite → PostgreSQL/Supabase. An agent skill from alexeykrol/claude-code-starter. | alexeykrol/ | 194 | — | ~405 | Automated safety check: Notes | No licence | 2 mo ago |
| 42 | Changes marchat SQL schema and queries across SQLite, PostgreSQL, and MySQL using dialect helpers. | Cod-e-Codes/ | 137 | — | ~985 | Automated safety check: Pass | MIT | 5 days ago |
| 43 | 43.SQL Insight Translate natural language to SQL, optimize query performance, and interpret EXPLAIN plans for SQLite and PostgreSQL. | zebbern/ | 4.7k | — | ~2.1k | Automated safety check: Pass | MIT | today |
| 44 | 44.SQL Queries Write correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.). | w95/ | 237 | 3 repos | ~2.8k | Automated safety check: Pass | MIT | 7 mo ago |
| 45 | 45.Web Sqli SQL injection detection→exploitation→proof for web apps and APIs. | s0ld13rr/ | 827 | — | ~710 | Automated safety check: Pass | MIT | 5 days ago |
| 46 | 46.Mz PR Review Local code review of current branch vs Materialize standards. | MaterializeInc/ | 6.4k | — | ~1.6k | Automated safety check: Notes | Unknown | today |
| 47 | Design Rust on Nails applications and cross-layer features using Axum, server-rendered Dioxus, PostgreSQL, and typed SQL. | bionic-gpt/ | 2.4k | — | ~706 | Automated safety check: Pass | Apache-2.0 | yesterday |
| 48 | 48.DB Review 数据库代码审查 + Migration 安全检查. An agent skill from 312362115/claude. | 312362115/ | 107 | — | ~1.8k | Automated safety check: Pass | MIT | 4 mo ago |