supabase-postgres-best-practices
supabase-postgres-best-practices is the official agent skill of Supabase published by supabase, listed under data & analysis. It lives in the supabase/agent-skills repository, which has 2,934 GitHub stars and is licensed under MIT; we last read it on 2026-09-16.
This repository contains best practices for managing a Postgres database, applicable for any environment. It covers schema design, migrations, security policies, performance tuning, and SQL authoring, required before making any changes to the database.
Install
skills is a generic installer for any repository of Claude agent skills -- it reads supabase/agent-skills’s own structure rather than assuming one, the same way this page reads the skill’s own SKILL.md rather than assuming a format.
npx skills add supabase/agent-skills
What it connects to
Unverified means a mention in the skill’s own description, not a citation. A wrong claim here costs nothing to correct and nothing to trust yet.
Maintenance
Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill BEFORE writing or changing anything that lives in a Postgres database: creating or altering tables and columns (including choosing column types), schema design, migrations and declarative schema files, RLS policies and the tests that verify them, indexes, triggers, database functions, queues and scheduled jobs (pg_cron, pgmq), vector/semantic search (pgvector), and restoring dumps (pg_restore) or importing data. Also load it when diagnosing slow queries, high CPU, timeouts, EXPLAIN plans, connection exhaustion, locking, bloat, or rows visible to the wrong user or tenant. This is not just a performance guide — schema, migration, security, and SQL authoring tasks need these rules too, even for a one-column change or a single query.
supabase-postgres-best-practices compared with similar skills
| Skill | Publisher | What it does | Repo stars | Last update |
|---|---|---|---|---|
| supabase-postgres-best-practices (this page) | supabase | Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill BEFORE writing… | 2,934 | 2026-10-02 |
| agent-platform-rag-engine-management | Manage and query Agent Platform RAG Engine Corpora and retrieve grounded contexts using the Google GenAI SDK.… | 21,580 | 2026-10-25 | |
| alloydb-basics | Manages clusters, instances, and backups for AlloyDB for PostgreSQL, and integrates with AlloyDB Model Contex… | 21,580 | 2026-10-25 | |
| bigquery-ai-ml | Leverages BigQuery's built-in machine learning and GenAI capabilities for advanced data analytics. Use when y… | 21,580 | 2026-10-25 | |
| bigquery-basics | Manages datasets, tables, and jobs in BigQuery. Use when you need to interact with BigQuery, run SQL queries,… | 21,580 | 2026-10-25 | |
| bigquery-bigframes | Generates Python code using BigQuery DataFrames (BigFrames). Use by default for any Python data task involvin… | 21,580 | 2026-10-25 | |
| bigtable-basics | Assists in provisioning instances/tables, designing performant schemas, and querying data in Bigtable. Use wh… | 21,580 | 2026-10-25 |
Skills from the same repository first, then others for this job by repository stars. Figures are from each repository when we last read it.
Common questions about supabase-postgres-best-practices
- What does supabase-postgres-best-practices do?
- This repository contains best practices for managing a Postgres database, applicable for any environment. It covers schema design, migrations, security policies, performance tuning, and SQL authoring, required before making any changes to the database.
- How do I install supabase-postgres-best-practices?
- Run npx skills add supabase/agent-skills. The skills installer reads the repository’s own structure, so it works for any repository of agent skills.
- Who publishes supabase-postgres-best-practices?
- supabase. It is named as the official skill of Supabase.
- Is supabase-postgres-best-practices maintained, and what licence does it use?
- Its repository has 2,934 GitHub stars and its state in our directory is listed. Its last commit we recorded was on 2026-10-02. The repository declares the MIT licence.
More agent skills for data & analysis
- case-study-writingby 101-skills
- python-executorby 101-skills
- marketplace-managerby bradautomates
- ebay-sold-listings-searchby browser-act
- facebook-page-postsby browser-act
- facebook-page-profile-postsby browser-act