PostgreSQL agent skills, page 7

PostgreSQL database patterns for query optimization, schema design, indexing, and security.

ThibautBaissac/rails_ai_agents

Full development environment setup from scratch — prerequisites, dependencies, .env file, optional local PostgreSQL database (for auth/collections/chat work), and dev server.

linuxfoundation/insights

Help users create and run a local Ethereum development environment with .NET Aspire — DevChain node, blockchain indexer, Blazor explorer, and PostgreSQL.

Nethereum/Nethereum

用本地前端插件连云端后端做端到端测试 / test the local VS Code extension against the deployed cloud backend.

FreakStudioCN/mpy-hardware-extension

Full Tusk release — bump version, build DMG, publish GitHub release, update README

Shape-Machine/tusk-macos

Builds and debugs retrieval with the gaik toolkit — PgVectorStore, Ranker, FinnishTextProcessor, RelevanceGate — as hybrid search: pgvector similarity plus Postgres full-text, fused by rank, and the…

GAIK-project/gaik-toolkit

Queries JGI Lakehouse (Dremio) for genomics metadata from GOLD, IMG, Mycocosm, Phytozome.

BioTender-max/awesome-bio-agent-skills

Backup a PostgreSQL database from a Railway environment. An agent skill from modelguide/modelguide.

modelguide/modelguide

Provision instant temporary Postgres databases via Claimable Postgres by Neon (pg.new).

henryalouf/ruflow

Seed reproducible local Langfuse data in ClickHouse and Postgres.

langfuse/langfuse

PostgreSQL query optimization, JSONB operations, advanced indexing strategies, partitioning, connection management, and database administration.

cin12211/orca-q

Switches cognee's LLM, embedding, relational, vector and graph backends through environment variables, with the extras to install and the traps to avoid.

topoteretes/cognee

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/evo-nexus

Versioning, branch, and release policy (semantic versioning, branch-per-minor, tag-per-patch).

relytcloud/pg_ducklake

创建或修改数据库 Schema。当需要创建新表、修改表结构、定义字段、设置索引约束、或涉及 Drizzle ORM / drizzle-zod 操作时使用

zhe-qi/clhoria-template

Read and write Delta tables and connect to Lakebase (OLTP PostgreSQL) from Databricks Apps.

databricks-solutions/databricks-apps-cookbook

Debug a failed Activepieces flow run end-to-end: given a flow run id (or BullMQ job id), find why it failed, cross-referencing the live BullMQ job + Postgres rows (SSH script on the DevOps box), the…

activepieces/activepieces

Run tests + pick test framework in Materialize. An agent skill from MaterializeInc/materialize.

MaterializeInc/materialize

Create and push a new semver release tag. An agent skill from ClickHouse/pg_stat_ch.

ClickHouse/pg_stat_ch

Comprehensive PostGIS spatial table design reference covering geometry types, coordinate systems, spatial indexing, and performance patterns for location-based applications

timescale/pg-aiguide

Complete module inventory of the Auth API project with file paths, dependencies, and architecture overview.

gjovanovicst/golang-auth-api

启动 Blockless 本地开发栈 / bring up the local dev stack. An agent skill from FreakStudioCN/mpy-hardware-extension.

FreakStudioCN/mpy-hardware-extension

Manage PostgreSQL migrations, typed SQL queries, generated Rust bindings, and database authorization in Rust on Nails applications.

bionic-gpt/bionic-gpt

Deploy a CipherStash encryption rollout to a live environment without losing data — the multi-deploy ladder (schema-add + dual-write → backfill → read cutover → stop dual-writes → drop plaintext)…

cipherstash/stack

A skill your agent uses when gating a feature behind a flag, dogfooding or gradually rolling out a change, choosing between productfeatures and PostHog feature flags, adding or checking a product…

speakeasy-api/gram

Tunes PostgreSQL and MySQL performance by analyzing slow queries and execution plans, designing indexes, rewriting queries and adjusting configuration, one validated change at a time.

Jeffallan/claude-skills

Tunes and administers PostgreSQL: EXPLAIN-driven query tuning, index choice, JSONB, extensions, streaming or logical replication, VACUUM and pg_stat monitoring.

Jeffallan/claude-skills

Optimizes SQL queries and designs schemas using CTEs, window functions, covering indexes and EXPLAIN ANALYZE, with notes on dialect differences between major databases.

Jeffallan/claude-skills

Wavelet 项目专用：当新增或修改数据库表结构、索引、初始化数据、系统配置 seed、模板 seed、默认管理员、goose SQL 迁移、internal/infra/persistence/migrator、ClickHouse 分析库 DDL 或数据库升级流程时必须使用。本技能指导在 internal/infra/persistence/migrator/goose 下编写…

Rain-kl/OpenFlare

Миграция схемы базы данных: SQLite → PostgreSQL/Supabase. An agent skill from alexeykrol/claude-code-starter.

alexeykrol/claude-code-starter

Build, fix, audit, and migrate Drift persistence in Dart CLI, server-side, and non-Flutter desktop apps.

MADTeacher/mad-agents-skills

Process use when you need to work with database indexing. An agent skill from jeremylongshore/tons-of-skills-marketplace.

jeremylongshore/tons-of-skills-marketplace

Restore a PostgreSQL database backup to a Railway environment.

modelguide/modelguide

数据库迁移最佳实践，涵盖模式变更、数据迁移、回滚以及零停机部署，适用于PostgreSQL、MySQL及常用ORM（Prisma、Drizzle、Django、TypeORM、golang-migrate）。

affaan-m/ECC

用于查询优化、模式设计、索引和安全性的PostgreSQL数据库模式。基于Supabase最佳实践. An agent skill from affaan-m/ECC.

affaan-m/ECC

Supply-chain security controls for the @cipherstash/stack monorepo.

cipherstash/stack

Overview of Neon, a complete set of cloud backend primitives for apps and agents, spanning Lakebase Postgres, Auth, the Data API, Object Storage, Compute Functions, and the AI Gateway.

smontlouis/bible-strong

Run make clean on the Tusk project and diagnose any errors. An agent skill from Shape-Machine/tusk-macos.

Shape-Machine/tusk-macos

Writing database migration SQL scripts. An agent skill from golemcloud/golem.

golemcloud/golem

A skill your agent uses when building, debugging, or evaluating CloudBase PostgreSQL / CloudBase PG / PG mode apps, including Postgres schema setup, queryPgDatabase/managePgDatabase, JS SDK v3…

TencentCloudBase/CloudBase-AI-Toolkit

Integrate CipherStash encryption with Drizzle ORM using @cipherstash/stack-drizzle (EQL v3).

cipherstash/stack

抓取并汇总"数据库、AI、GitHub、AI 论文"近 1 周新闻，输出图文并茂（含 mermaid 图）的 markdown 周报到当前项目的 markdown/ 目录。覆盖 10 个数据源：postgresweekly.com/issues（自动解析最新 issue…

digoal/blog

Changes marchat SQL schema and queries across SQLite, PostgreSQL, and MySQL using dialect helpers.

Cod-e-Codes/marchat

MUST use when writing PostgreSQL queries. An agent skill from windmill-labs/windmill.

windmill-labs/windmill

쿼리 최적화, 스키마 설계, 인덱싱, 보안을 위한 PostgreSQL 데이터베이스 패턴. An agent skill from affaan-m/ECC.

affaan-m/ECC

将单行目标转化为多会话、多代理工程项目的分步构建计划。每个步骤包含独立的上下文简介，以便新代理能直接执行。包括对抗性审查门、依赖图、并行步骤检测、反模式目录和计划突变协议。触发条件：当用户请求复杂多PR任务的计划、蓝图或路线图，或描述需要多个会话的工作时。不触发条件：任务可在单个PR或少于3个工具调用中完成，或用户说“直接执行”时。

affaan-m/ECC

FastAPI 项目一键初始化技能。面向零基础小白，提供环境探测、自动安装、完整 Web 骨架生成、SSE 流式框架、JWT 鉴权、统一响应封装、文件上传接口、一键启动/重启脚本、Swagger 文档，内置 MySQL（默认）/ PostgreSQL / MongoDB 数据库选择。用户只需说"帮我搭一个 FastAPI 项目"即可一条命令完成从零到跑的完整链路。触发词："FastAPI…

jiushiwon/wg-skills

Translate natural language to SQL, optimize query performance, and interpret EXPLAIN plans for SQLite and PostgreSQL.

zebbern/claude-code-guide