# Postgres Patterns (agent skill)

> Postgres Patterns is an agent skill (a SKILL.md file) from affaan-m/ECC. PostgreSQL database patterns for query optimization, schema design, indexing, and security. It works with Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot and OpenCode and has 274,402 GitHub stars across a repository of 10 listed skills.

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices. Use when designing PostgreSQL schemas, indexes, or RLS policies, or when a query is too slow. Quick reference for PostgreSQL best practices. For detailed guidance, use the database-reviewer agent.

## Key facts

| Fact | Value |
|---|---|
| Repository | https://github.com/affaan-m/ECC |
| Skill path | skills/postgres-patterns/SKILL.md |
| Skill name | postgres-patterns |
| GitHub stars | 274,402 |
| Installs on skills.sh | 2 |
| License | MIT |
| Skills in repo | 10 |
| Plugin marketplace | ecc |
| Official | no |
| Works with | Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, OpenCode |
| Category | Security |
| Last commit | Oct 2, 2026 |

## When it triggers

- Use when designing PostgreSQL schemas, indexes, or RLS policies, or when a query is too slow.

## Add this skill

### Claude Code

```sh
/plugin marketplace add affaan-m/ECC
/plugin install ecc@ecc
```

In the Claude apps, zip the skill folder and upload it under Customize > Skills > + > Upload a skill (code execution must be on).

### ChatGPT / Codex

```sh
git clone --depth 1 https://github.com/affaan-m/ECC.git
cp -r ECC/skills/postgres-patterns .agents/skills/postgres-patterns   # repo; ~/.agents/skills for all projects
```

### Cursor

```sh
git clone --depth 1 https://github.com/affaan-m/ECC.git
cp -r ECC/skills/postgres-patterns .cursor/skills/postgres-patterns   # project; ~/.cursor/skills for all projects
```

Sources (checked 2026-10-07): https://code.claude.com/docs/en/skills, https://support.claude.com/en/articles/12512180-using-skills-in-claude, https://learn.chatgpt.com/docs/build-skills, https://cursor.com/docs/context/skills

skills.sh listing: https://www.skills.sh/affaan-m/ECC/postgres-patterns

---

Canonical page: https://appsgit.com/skills/affaan-m-postgres-patterns
Source: appsgit (https://appsgit.com), the app store for github. Data from the GitHub API, refreshed nightly.
Machine access: JSON API https://appsgit.com/api/v1/apps (OpenAPI: https://appsgit.com/openapi.json), MCP server https://mcp.appsgit.com/mcp, full index https://appsgit.com/llms-full.txt.