Agent skill · Audited from source
Postgres Best Practices
skill · Dokhacgiakhoa/antigravity-ideNOASSERTION licenceAudited 19 Oct 2026 · source d1a0c85a714a
Is it safe? Yes — SAFE, grade B (89/100). We read this skill's source at commit d1a0c85a714a and found no filesystem, network or shell access and no hard-coded secrets. What it does: PostgreSQL and Supabase optimization guide.
Cite
Cite this page
ModelsAtlas. “Postgres Best Practices (Dokhacgiakhoa/antigravity-ide)”. Retrieved 19 Oct 2026. https://modelsatlas.com/skills/dokhacgiakhoa/postgres-best-practices
Trust audit
Audit 0.4.1 · source read 19 Oct 2026
SAFE means nothing in the source contradicts what the skill says it does. Grade B is shared by 17,406 of 18,389 audited skills.
What the source does
- FilesystemNone observedNo reads or writes in the source
- NetworkNone observedNo outbound calls in the source
- ShellNone observedNo commands run in the source
- DependenciesPinnedNothing floats
- SecretsNone foundNo keys in source
Five audit layers
| Layer | What we check | Result | Findings |
|---|---|---|---|
L0 Provenance | Repo owner, licence, archive status, activity | PASS | 0 |
L1 Static source | Secrets, path traversal, supply chain, hidden code | NA | 0 |
L2 Instructions | Prompt injection, authority framing, hidden directives | PASS | 0 |
L3 Inventory | The files and declarations match the source | PASS | 0 |
L4 Sandbox | Run in isolation and watch behaviour | SKIPPED why | 0 |
Gates applied: no behavioural pass.
Findings (0)
No findings at any severity. We re-audit when the source changes.
Audit 0.4.1 · source sha d1a0c85a714a · 19 Oct 2026Report an issue or request a re-scan
Provenance
Who published it, and what the verdict is pinned to
- PublisherDokhacgiakhoa GitHub userOwner of the repository this skill is read from
- Source folderDokhacgiakhoa/antigravity-ide/.agent/skills/postgres-best-practicesThe exact folder we audited
- LicenceNOASSERTIONAs the repository states it
- Commit pinned for this verdictd1a0c85a714aA new audit runs when the source changes
- Repository statusNot archivedLast push 130 days ago
- Sandboxed runNot runSkills are read, not executed; layer L4 is skipped
What it tells the agent
Full source on GitHub ↗Its description: PostgreSQL and Supabase optimization guide.
---
name: postgres-best-practices
description: PostgreSQL and Supabase optimization guide.
category: development
version: 4.1.0-fractal
layer: master-skill
---
# PostgreSQL Best Practices
> **Goal**: Design scalable, secure, and performant database schemas and queries, specifically optimized for Supabase/PostgreSQL environments.
## 1. Schema Design
- **Normalization**: Aim for 3NF (Third Normal Form) to reduce redundancy.
- **Primary Keys**: Use `UUID` (v7 or v4) or `BIGINT` (Identity) for primary keys. Avoid simplistic auto-increment `INT` if scaling horizontally.
- **Naming**: Use `snake_case` for table and column names. Plural for tables (`users`, `orders`).
- **Foreign Keys**: Always define foreign key constraints to ensure data integrity. Index all FK columns.
## 2. Performance & Indexing
- **Indexes**:
- **B-Tree**: Default for equality and range queries.
- **GIN**: For JSONB and Full-Text Search (`tsvector`).
- **GiST**: For Geo-spatial data (`PostGIS`).
- **Composite Indexes**: Create composite indexes for columns frequently queried together (order matters: equality first, then range).
- **Explain Analyze**: Always check `EXPLAIN ANALYZE` on complex queries to verify index usage.
## 3. Security (Row Level Security - RLS)
- **Enable RLS**: `ALTER TABLE "table_name" ENABLE ROW LEVEL SECURITY;`
- **Policies**: Define strict policies for `SELECT`, `INSERT`, `UPDATE`, `DELETE`.
- *Example*: `auth.uid() = user_id` for user-private data.
- **Service Role**: Use service role keys only for backend admin tasks; never expose to client.
## 4. JSONB vs Relational
- **When to use JSONB**:
- Dynamic payload (e.g., webhook responses, configuration settings).
- Data structure varies significantly per row.
- **When NOT to use JSONB**:
- Data that needs frequent joining or aggregating.
- Data that requires foreign key constraints.
## 5. Application Usage (Prisma/Supabase JS)
- **Connection Pooling**: Use Supabase Transaction Pooler (port 6543) for serverless functions to avoid connection exhaustion.
- **N+1 Problem**: Be wary of N+1 queries in ORMs (Prisma). Use `.include()` or explicit joins carefully.
---
**Supabase Specific**:
- **Realtime**: Only enable Realtime for tables that specifically need it (to save resources).
- **Storage**: Use RLS policies for Storage Buckets file access as well.Excerpt, first 2,370 characters of SKILL.md, verbatim from the audited commit. It is text from someone else’s repository, quoted so you can judge it before your agent reads it.
Install
Pinned to the audited commit d1a0c85
git clone https://github.com/Dokhacgiakhoa/antigravity-ide git -C antigravity-ide checkout d1a0c85a714a
The author documents no install command, so this uses the repository directly. Our verdict covers commit d1a0c85a714a only.
Works in
The author has not said which agents this skill supports, and we have not tested it in any.
Audit history
Every audit, every source change
- ✓SAFE B 89 / 100
first audit · source
d1a0c85a714a
Similar skills
All coding & review skills →Dokhacgiakhoa/antigravity-ide
2D game development principles.
Dokhacgiakhoa/antigravity-ide
3D game development principles.
Dokhacgiakhoa/antigravity-ide
Multi-agent orchestration and state management.
Dokhacgiakhoa/antigravity-ide
Principal AI Architect and Machine Learning Engineer.
Dokhacgiakhoa/antigravity-ide
Opinionated coding style and tooling preferences by Anthony Fu.
Dokhacgiakhoa/antigravity-ide
Master API documentation with OpenAPI 3.1.
Questions about Postgres Best Practices
Is Postgres Best Practices safe to install?
What can Postgres Best Practices access on my machine?
How current is this page?
Sources
- github.com/Dokhacgiakhoa/antigravity-ide/tree/main/.agent/skills — the audited source at commit d1a0c85a714a and every finding aboveObserved · 19 Oct 2026
Spotted something wrong? Report a correction · Methodology
Keep going in your AI
Opens with this page as the source. We add nothing else to the prompt.
- Is Postgres Best Practices safe to install?
- What can Postgres Best Practices access on my machine?
- How current is this page?