--- title: Introducing: Postgres Best Practices | daily.dev description: Supabase released Agent Skills for Postgres Best Practices, a collection of 30 rules across 8 categories to help AI coding agents write correct, performant... canonical: https://daily.dev/posts/introducing-postgres-best-practices-oieboe2rs twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Introducing: Postgres Best Practices | daily.dev og:description: Supabase released Agent Skills for Postgres Best Practices, a collection of 30 rules across 8 categories to help AI coding agents write correct, performant... og:url: https://daily.dev/posts/introducing-postgres-best-practices-oieboe2rs og:image: https://api.daily.dev/og/posts/oIEBoE2RS.png og:image:alt: Introducing: Postgres Best Practices og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Introducing: Postgres Best Practices **[Supabase](https://daily.dev/sources/supabase)** · 4 min read · 493 upvotes · 8 comments ## Summary Supabase released Agent Skills for Postgres Best Practices, a collection of 30 rules across 8 categories to help AI coding agents write correct, performant Postgres code. The rules follow the Agent Skills open standard and cover critical areas like query performance, connection management, Row Level Security, schema design, and concurrency. The repository addresses common mistakes seen across hundreds of thousands of Postgres projects, such as missing indexes, RLS bypasses, and connection pool exhaustion. These best practices complement the Supabase MCP server by teaching agents proper judgment while the MCP server handles database connections and execution. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Community discussion Top comments from developers on daily.dev. **@alexeyzerkalenkov** · 5 upvotes > This are the missing parts of the AI puzzle: > >The agent treats the rules as authoritative guidance rather than generating advice from its training data. > > >The MCP server gives agents the ability to work with your database. These best practices teach them to do it correctly. > > Such things are really multiplying our productivity! Thanks @supabase! **@allinonetools** · 1 upvotes > Great move by Supabase. > > Most AI agents can write SQL that *works*, but not SQL that’s **safe, scalable, and production-ready**. > Having Postgres best practices in an Agent Skills format is exactly what AI coding tools were missing. > > This could prevent a lot of silent performance and RLS mistakes before they hit production. **@hanzo\_vnn** · 0 upvotes > As a newbie developer, I am overwhelming by technologies around the world, this is one of 100 posts that completely change me. **@a1ryang** · 0 upvotes > Thank you. I appreciate this. **@raj247** · 0 upvotes > This is such a needed move 👏 > > Giving agents _explicit Postgres judgment_ instead of just execution power is the real unlock. I love the framing — MCP as the steering wheel, and these best practices as the driving lessons. That’s exactly how agentic systems should be designed: capability + guardrails. > > As someone building AI-powered apps on top of Supabase/Postgres, I’ve seen firsthand how easy it is for agents (and even devs) to miss RLS nuances, indexing trade-offs, or connection pool limits. Packaging production-grade DB wisdom into machine-readable skills is a very strong step toward... ## Similar posts on daily.dev - [AI Agents Know About Supabase. They Don't Always Use It Right.](https://daily.dev/posts/ai-agents-know-about-supabase-they-don-t-always-use-it-right--jdyn6pgoc) · Supabase · 41 upvotes · 3 comments --- Tags: [#ai](https://daily.dev/tags/ai), [#database](https://daily.dev/tags/database), [#postgresql](https://daily.dev/tags/postgresql), [#supabase](https://daily.dev/tags/supabase) [View this post on daily.dev](https://daily.dev/posts/introducing-postgres-best-practices-oieboe2rs) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Introducing: Postgres Best Practices","url":"https://daily.dev/posts/introducing-postgres-best-practices-oieboe2rs","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/introducing-postgres-best-practices-oieboe2rs"},"datePublished":"2026-01-22T13:02:55.203Z","dateModified":"2026-01-22T13:03:19.060Z","description":"Supabase released Agent Skills for Postgres Best Practices, a collection of 30 rules across 8 categories to help AI coding agents write correct, performant...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/12090fe88a62f5c7f1a0896b6abc8e96?_a=AQAEulh","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/12090fe88a62f5c7f1a0896b6abc8e96?_a=AQAEulh","isAccessibleForFree":true,"articleSection":"Supabase","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Supabase","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/d0aa77cfb88d44dd8e6d5cd02fdf80bd","url":"https://daily.dev/sources/supabase"},"commentCount":8,"discussionUrl":"https://daily.dev/posts/introducing-postgres-best-practices-oieboe2rs","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":493},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":8}],"keywords":"ai,database,postgresql,supabase","timeRequired":"PT4M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Supabase","item":"https://daily.dev/sources/supabase"},{"@type":"ListItem","position":3,"name":"Introducing: Postgres Best Practices"}]} {"@context":"https://schema.org","@type":"WebPage","@id":"https://daily.dev/posts/introducing-postgres-best-practices-oieboe2rs","comment":[{"@type":"Comment","text":"This are the missing parts of the AI puzzle:\n\nThe agent treats the rules as authoritative guidance rather than generating advice from its training data.\n\n\nThe MCP server gives agents the ability to work with your database. These best practices teach them to do it correctly.\n\nSuch things are really multiplying our productivity! Thanks @supabase!","datePublished":"2026-01-23T07:52:13.225Z","url":"https://daily.dev/posts/oIEBoE2RS#c-1flPdlNoL","author":{"@type":"Person","name":"Alexey Zerkalenkov","url":"https://daily.dev/alexeyzerkalenkov","image":"https://lh3.googleusercontent.com/a/ACg8ocKQBwPwaHC4XrPy0rniDybogCxlwDp7QCLkbwsqNRQSFhqDIlIf=s96-c"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":5}},{"@type":"Comment","text":"Great move by Supabase.\nMost AI agents can write SQL that works, but not SQL that’s safe, scalable, and production-ready.\nHaving Postgres best practices in an Agent Skills format is exactly what AI coding tools were missing.\nThis could prevent a lot of silent performance and RLS mistakes before they hit production.","datePublished":"2026-02-02T15:59:51.987Z","url":"https://daily.dev/posts/oIEBoE2RS#c-OzxBYr0ub","author":{"@type":"Person","name":"AllInOneTools","url":"https://daily.dev/allinonetools","image":"https://media.daily.dev/image/upload/s--4ZT8QlF0--/f_auto/v1769790028/avatars/avatar_igzBsWloJeaegzm9bQltZ?_a=BAMAMiiu0"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1}},{"@type":"Comment","text":"As a newbie developer, I am overwhelming by technologies around the world, this is one of 100 posts that completely change me.","datePublished":"2026-02-04T01:43:54.290Z","url":"https://daily.dev/posts/oIEBoE2RS#c-dOzG1xIky","author":{"@type":"Person","name":"Khiem Tran","url":"https://daily.dev/hanzo_vnn","image":"https://media.daily.dev/image/upload/s---BSD_rU5--/f_auto/v1769652892/avatars/avatar_rXCrqsfTiFKAASSdGFSMr?_a=BAMAMiiu0"}},{"@type":"Comment","text":"Thank you. I appreciate this.","datePublished":"2026-01-24T01:59:54.109Z","url":"https://daily.dev/posts/oIEBoE2RS#c-BUq5btA70","author":{"@type":"Person","name":"Aaron Gayah","url":"https://daily.dev/a1ryang","image":"https://lh3.googleusercontent.com/a/ACg8ocIih1uI1ERJ-uxuFjzzWoPUW7A1gKMyWQvOLugFEx8ZRyzJhg=s96-c"}},{"@type":"Comment","text":"This is such a needed move 👏\nGiving agents explicit Postgres judgment instead of just execution power is the real unlock. I love the framing — MCP as the steering wheel, and these best practices as the driving lessons. That’s exactly how agentic systems should be designed: capability + guardrails.\nAs someone building AI-powered apps on top of Supabase/Postgres, I’ve seen firsthand how easy it is for agents (and even devs) to miss RLS nuances, indexing trade-offs, or connection pool limits. Packaging production-grade DB wisdom into machine-readable skills is a very strong step toward reliable agent workflows.\nExcited to experiment with this alongside MCP in my Next.js + Supabase stack — this is the direction AI-assisted backend engineering should go.","datePublished":"2026-02-11T05:01:13.898Z","url":"https://daily.dev/posts/oIEBoE2RS#c-74AEPMBqX","author":{"@type":"Person","name":"Raj Dutta","url":"https://daily.dev/raj247","image":"https://avatars.githubusercontent.com/u/154328348?v=4"}}]} ```