Affaan MustafaTrading lead at Jump Trading; ECC 290k+ stars6,900 installs on skills.shPostgres Patterns
PostgreSQL database patterns for query optimization.
Use Edge to load the skill postgres-patterns from affaan-m/ecc for my task. If Edge is not set up, read getedge.cc/SKILL.md and ask me first.
2 static scans, 0 counted findings.
Edge checks it again each time your agent loads it.
What it 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.
Why Affaan Mustafa
Compute Trading Lead at Jump Trading. Each fact links its public source.
- Role at Jump Trading
His GitHub bio says Compute Trading Lead at Jump Trading, previously founding The Agentic Desk.
GitHub profile - Hugely starred agent harness repo
ECC has 290k+ GitHub stars.
GitHub repo - Security tool with traction
agentshield has 1.3k+ GitHub stars.
GitHub repo
How it works
- 1Copy
Try for free gives you one prompt.
- 2Paste
Paste it into Claude Code, Codex or Cursor.
- 3Ask
Ask for the outcome. Your agent loads Postgres Patterns.
Related skills
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads. Use when writing ClickHouse schemas or queries, or when an analytical query is t
Database schema design, optimization, and migration patterns for PostgreSQL, MySQL, and NoSQL databases. Use for designing schemas, writing migrations, or optimizing queries.
MySQL and MariaDB schema, query, indexing, transaction, replication, and connection-pool patterns for production backends. Use when designing MySQL or MariaDB schemas and indexes, or when a query, transaction, or replica
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing
PostgreSQL-specific code review assistant focusing on PostgreSQL best practices, anti-patterns, and unique quality standards. Covers JSONB operations, array usage, custom types, schema design, function optimization, and
Use this skill when designing or reviewing a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
No evidence record yet
No measured run with and without this skill yet, so this page makes no performance claim. 2 static scans, 0 counted findings. Security state at 2026-11-17: reviewed. Static scans check the code, not how well the skill works.
State definitionsSelect the Files tab to load SKILL.md.
Skill details
Security scansReviewed
2 static scans, 0 counted findings. Security state at 2026-11-17: reviewed. Edge checks it again each time your agent loads it.
Edge static checks (Edge-run): edge-static/1.0.2. Scope: Static patterns for remote execution, credentials with network sends, obfuscation, prompt overrides, hidden Unicode, binaries and persistence. Raw findings: not supplied.
Edge committed-secret checks (Edge-run): edge-secrets/1.0.0. Scope: Credentials committed in the skill's files (values never shown). Raw findings: not supplied.
Socket (skills.sh mirror): Version unavailable. Scope: Not supplied by the mirrored record. Raw findings: not supplied.
Snyk (skills.sh mirror): Version unavailable. Scope: Not supplied by the mirrored record. Raw findings: not supplied.
- Edge static checks
- Pass · 0 counted findings · 2026-11-17
- Edge committed-secret checks
- Pass · 0 counted findings · 2026-11-17
Creator, source & licenceaffaan-m
From the affaan-m public repository. Edge did not write or edit this skill.
- Repository
- affaan-m/ecc
- Skill file
- View source at revision
- Revision
- d3b8a3e908904e242ed2dbe66af62cca71131419
- Package hash
- sha256:f28624d6b9d9f75c89dee27d829df0d5476c1422029251d6222dfbb795b3eed6
- Licence
- MIT
- Description
- 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.
Quoted from the skill’s own description
Read skill files1 file
1 file, 3.8 KB at revision d3b8a3e90890.
Questions about Postgres Patterns
What does Postgres Patterns do?
PostgreSQL database patterns for query optimization. Published by Affaan Mustafa (affaan-m/ecc).
Is Postgres Patterns safe to use?
Edge security state: Reviewed (2 Edge-run static scans, scanned Nov 17, 2026). The Evidence tab shows the scan.
How do I use Postgres Patterns in Claude Code, Codex or Cursor?
Click Try for free, pick your agent and follow its one step. Edge is free, with no Edge account.