What problem does it solve? Setting up and operating a Postgres database for a Netlify app involves provisioning, connection management, schema migrations, and environment-specific branching. This Skill provides the exact commands, code patterns, and safety rules for Netlify Database so agents and developers configure it correctly without searching documentation. ## Core Features & Use Cases - Zero-config Postgres client: Query with getDatabase() from @netlify/database using auto-parameterized SQL templates, streaming, transactions via pg.Pool, or bring your own driver with getConnectionString(). - Migration workflow: Write SQL migrations in netlify/database/migrations/ or generate them with Drizzle Kit; Netlify applies them automatically on deploy previews and production publishes. - Drizzle ORM integration: Set up the drizzle-orm/netlify-db adapter, configure drizzle.config.ts output to the Netlify migrations directory, and avoid the drizzle-kit push/migrate footguns. - Use Case: Build a CRUD API for a contact form — run netlify database init, define a Drizzle schema, generate a migration, write a Netlify Function that inserts and reads rows, test locally with netlify dev, and deploy with an isolated preview database branch. ## Quick Start Ask the agent to set up Netlify Database in my project with a users table, a Drizzle schema, and a serverless function that reads and writes rows.
