Introducing: Postgres Best Practices

Supabase has released a set of Agent Skills to guide AI agents in generating high-quality, correct code for Postgres databases, addressing common mistakes like missing indexes, security oversights, and inefficient queries. These skills are organized into eight categories, prioritized by impact, and serve as explicit guidelines rather than relying solely on the agent's training data. The goal is to enhance the agents' ability to manage Postgres databases effectively by providing authoritative rules that they can reference when writing queries, reviewing code, or suggesting schema changes. Supabase has packaged this internal knowledge into a format compatible with tools like Claude Code, GitHub Copilot, and others, enabling agents to apply best practices and avoid common pitfalls in Postgres management. This initiative also encourages community contributions to expand the repository with additional insights and rules. The Agent Skills format is part of an open standard developed by Anthropic and adopted across the industry, similar to initiatives by Vercel and Cloudflare.