postgres skills

91 tagged postgres, measured the same way as everything else here.

Browse within: postgresql 30supabase 28realtime 22firebase 20postgrest 20sql 13human-in-the-loop 9agent-harness 8change-control 8hackathon 8migrations 6performance 6plugin 6docker 5

react-hook-form

01

supabase/supabase

Skill Claude CodeCodex

Correct React Hook Form usage anywhere in the monorepo — data flow, subscriptions, reset, dirty state, number inputs, and controlled-input rules. Load this BEFORE writing or modifying ANY form code, adding a field to an existing form, touching watch/useWatch/formState/getValues/setValue/reset, wiring a form into a…

109k yesterday A 123 tokens original Apache-2.0

safe-sql-execution

02

supabase/supabase

Skill Claude CodeCodex

Use 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 and never says "security," "injection," or "SafeSqlFragment." This covers: writing or editing any pg-meta function, query builder, or endpoint…

109k yesterday A 221 tokens original Apache-2.0

studio-e2e-tests

03

supabase/supabase

Skill Claude CodeCodex

Write and run Playwright E2E tests for Supabase Studio (e2e/studio). Use when asked to run e2e tests, write new E2E tests, or debug flaky or failing Playwright tests. Covers running commands, avoiding race conditions, waiting strategies, selectors, helper functions, and CI vs local differences.

109k yesterday A 74 tokens original Apache-2.0

prest/prest

Skill Claude CodeCodexCursor

Guides writing and reviewing pREST Docker/network integration tests under integration/ so each request is human-readable via step comments or table-driven descriptions. Use when adding or editing integration//test.go, HTTP controller E2E coverage, make test-integration, test-integration-postgres…

4.6k 4d ago A 78 tokens original MIT

prest/prest

Skill Claude CodeCodexCursor

Guides classifying, gap-analyzing, and scaffolding support for a new SQL database in pREST (wire-compatible variants like TimescaleDB or new dialects). Use when adding database support, creating integration/ /, DIFFERENCES.md, adapters/ , per-DB docker-compose or GitHub workflows, or planning where config/app wiring…

4.6k 4d ago A 79 tokens original MIT

butterbase

06

butterbase-ai/butterbase

Skill Claude CodeCodex

AI-native, open-source backend-as-a-service with a built-in Model Context Protocol server. Postgres, auth, storage, functions, AI gateway.

3.4k +21 yesterday A 34 tokens original Apache-2.0

code-quality

07

piomin/claude-ai-spring-boot

Skill Claude CodeCodex

Comprehensive code review for Java - clean code principles, API contracts, null safety, exception handling, and performance. Use when user says "review code", "refactor", "check API", or before merging changes.

1.3k 4mo ago A 47 tokens original Apache-2.0

design-patterns

08

piomin/claude-ai-spring-boot

Skill Claude CodeCodex

Common design patterns with Java examples (Factory, Builder, Strategy, Observer, Decorator, etc.). Use when user asks "implement pattern", "use factory", "strategy pattern", or when designing extensible components.

1.3k 4mo ago A 47 tokens original Apache-2.0

spring-boot

09

piomin/claude-ai-spring-boot

Skill Claude CodeCodex

Spring Boot 3.x development - REST APIs, JPA, Security, Testing, and Cloud-native patterns. Use for building enterprise Java applications with Spring Boot.

1.3k 4mo ago A 36 tokens original Apache-2.0

pgrundev/pgbot

Skill Claude CodeCodex

Diagnose PostgreSQL health and performance using the read-only pgbot tool. Use for slow databases, expensive queries, unused indexes, disk usage, bloat, autovacuum, vacuum health, and configuration questions.

822 4d ago C 48 tokens

new-lint

11

supabase/splinter

Skill Claude CodeCodex

Create a new splinter lint — a SQL view that checks for a database anti-pattern. Use this skill when the user asks to add a lint, create a new check, implement a linting rule, or extend splinter with a new detection.

270 5d ago A 54 tokens

gregs1104/pgbent

Skill Claude CodeCodexCursor

Tune Matplotlib labels on pgbent PG18 charts: scatter point placement, horizontal bar value labels (inside bar with contrast color when they fit), overlap avoidance, and PNG regeneration. Use when fixing crowded scatter or bar labels, pg18-osm-power-.png, pg18-osm-relation-power.png, pg18-osm-relation-scatter.png…

269 16d ago A 89 tokens

t1mmen/srtd

Skill Claude CodeCodex

Structured code review workflow for SRTD development. Use after implementing features, fixing bugs, or before merging to main. Ensures production-readiness through systematic review.

105 6mo ago A 38 tokens original MIT

srtd-cli

15

t1mmen/srtd

Skill Claude CodeCodex

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/, when .buildlog.json or srtd.config.json is detected, or when writing Postgres functions/views/triggers for Supabase.

105 6mo ago A 75 tokens original MIT

srtd-dev

16

t1mmen/srtd

Skill Claude CodeCodex

Expert knowledge for developing the SRTD codebase itself. Use when implementing features, fixing bugs, understanding architecture, or writing tests for SRTD internals. NOT for end users of srtd CLI.

105 6mo ago A 46 tokens original MIT

playwright-cli

17

pgEdge/ai-dba-workbench

Skill Claude CodeCodex

Automates browser interactions for web testing, form filling, screenshots, and data extraction. Use when the user needs to navigate websites, interact with web pages, fill forms, take screenshots, test web applications, or extract information from web pages.

46 4d ago A 52 tokens PostgreSQL

Knuckles-Team/vector-mcp

Skill Claude CodeCodex

Select and connect the right vector-store backend for the vector-mcp MCP server — chromadb, postgres/pgvector, qdrant, couchbase, or mongodb — and supply the correct dbtype/connection parameters that every collection and search call needs. Use when the agent must decide which engine to target, wire up…

15 3d ago A 113 tokens original MIT

squish-memory

19

michielhdoteth/squish-memory

Skill Claude CodeCodex

Persistent memory system for Claude Code. Use when you need to store, recall, or search project memories, facts, decisions, and learnings across sessions. Triggers on: remember, recall, memory, forget, search memories, store context, project knowledge, what did we decide, previous conversation.

11 4d ago A 65 tokens original MIT

squish

20

michielhdoteth/squish-memory

Skill Claude CodeCodex

ALWAYS use this skill when working with agents, memory, context, persistence, or AI agent state. Use when the user mentions: 'the agent forgot', 'save this', 'remember that', 'context is lost', 'memory', 'MCP server', 'agent memory', 'persistent memory', 'session context', 'project context', 'recall', 'remember'…

11 4d ago A 157 tokens original MIT

postgram

21

ivo-toby/postgram

Skill Claude CodeCodex

Use the pgm CLI (Postgram) to persist, search, and link knowledge across sessions. Invoke whenever the user wants to remember something across conversations, recall prior context, search their personal knowledge base, track tasks, or explore relationships between stored entities. Assumes pgm is on PATH, PGMAPIURL is…

7 1mo ago A 112 tokens AGPL-3.0

api-design

22

dunialabs/mcp-servers

Skill Claude CodeCodex

RESTful API design best practices including resource naming, HTTP methods, status codes, filtering, pagination, authentication, and OpenAPI documentation. Use when designing or reviewing REST APIs, web APIs, or API endpoints.

7 4mo ago A 45 tokens original MIT

markdown-formatter

23

dunialabs/mcp-servers

Skill Claude CodeCodex

Markdown formatting and linting guide with CommonMark specification and GitHub Flavored Markdown. Format .md files, fix syntax issues, generate tables of contents. Use when working with markdown files, README files, documentation, or when user needs markdown formatting help.

7 4mo ago A 55 tokens original MIT

pdf-processing

24

dunialabs/mcp-servers

Skill Claude CodeCodex

Extract text and tables from PDF files, merge/split documents, fill forms, add watermarks, create PDFs from scratch. Use when working with PDF files or when user mentions PDFs, forms, document extraction, or PDF manipulation.

7 4mo ago A 49 tokens original MIT