Postgres Patterns
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.
github.com/affaan-m/ECC/skills/postgres-patterns (opens in a new tab)
- Multi-skill repo
- Plugin marketplace
- Security
- Actively maintained
Add this skill
Claude
This repository is a Claude Code plugin marketplace. In Claude Code:
/plugin marketplace add affaan-m/ECC
/plugin install ecc@eccIn the Claude apps, zip the postgres-patterns folder and upload it under Customize > Skills > + > Upload a skill (code execution must be on).
ChatGPT / Codex
Codex reads skills from .agents/skills/ in a repo or ~/.agents/skills/ for every project:
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 projectsStandalone skills also load in the ChatGPT desktop app.
Cursor
Cursor loads skills from .cursor/skills/ (or ~/.cursor/skills/) and also reads .claude/skills/:
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 projectsSource (checked Oct 7, 2026): code.claude.com/docs/en/skills (opens in a new tab), code.claude.com/docs/en/plugin-marketplaces (opens in a new tab), support.claude.com/en/articles/12512180-using-skills-in-claude (opens in a new tab), learn.chatgpt.com/docs/build-skills (opens in a new tab), cursor.com/docs/context/skills (opens in a new tab)
What this skill does
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.
When it triggers
- Use when designing PostgreSQL schemas, indexes, or RLS policies, or when a query is too slow.
More skills in affaan-m/ECC
10 skills are listed from this repository.
Similar skills
More security skills
Wizard
mattpocock/skills
Generate an interactive bash wizard that walks a human through steps only they can perform.
SecurityShellPonytail Audit
DietrichGebert/ponytail
Whole-repo audit for over-engineering. Like ponytail-review, but scans the entire codebase instead of a diff: a ranked list of what to delete, simplify, or replace with stdlib/native equivalents.
SecurityJavaScriptNext Bundle Optimizer
vercel/next.js
Audit and reduce Next.js browser initial-load work.
OfficialSecurityJavaScriptCloud
browser-use/browser-use
Documentation reference for using Browser Use Cloud — the hosted API and SDK for browser automation.
OfficialSecurityPythonSecurity And Hardening
addyosmani/agent-skills
Hardens code against vulnerabilities. Use when auditing an input handler for vulnerabilities, when handling user input, authentication, data storage, or external integrations, or when checking a…
SecurityJavaScriptDoubt Driven Development
addyosmani/agent-skills
Subjects every non-trivial decision to a fresh-context adversarial review before it stands.
SecurityJavaScript
What is the Postgres Patterns 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. Its SKILL.md lives at github.com/affaan-m/ECC/skills/postgres-patterns.
How do I install the Postgres Patterns skill?
In Claude Code, run /plugin marketplace add affaan-m/ECC and then /plugin install ecc@ecc. For Codex or Cursor, copy the postgres-patterns folder into .agents/skills/ or .cursor/skills/.
Is the Postgres Patterns skill free?
Yes. The repository is open source under the MIT license.
Is Postgres Patterns maintained?
The repository's most recent commit was on Oct 2, 2026. Its latest release is v2.2.3. appsgit only lists skills from repositories with a commit in the last six months.