# PostgreSQL

A PostgreSQL database is provisioned automatically for every project when you call create_project — there is no flag to enable it and no separate step. The DATABASE_URL is injected automatically on every deploy — do not hardcode it.

## Mandatory connection pattern

Use npm:pg with ssl: false. The database is on an IPv6 host and does not support SSL from app code.

```typescript
import { Pool } from "npm:pg";

function pgConfig(s: string) {
  const u = new URL(s);
  return {
    host: u.hostname.replace(/^\[|\]$/g, ""),
    port: parseInt(u.port) || 5432,
    user: u.username,
    password: decodeURIComponent(u.password),
    database: u.pathname.slice(1).split("?")[0],
    ssl: false,
    connectionTimeoutMillis: 8000,
  };
}

const pool = new Pool(pgConfig(Deno.env.get("DATABASE_URL")!));

export default async function handler(req: Request): Promise<Response> {
  const { rows } = await pool.query("SELECT NOW() as time");
  return Response.json({ time: rows[0].time });
}
```

## Schema setup

Create schema BEFORE the first deploy using the execute_sql tool:

```sql
CREATE TABLE IF NOT EXISTS items (
  id   SERIAL PRIMARY KEY,
  name TEXT NOT NULL,
  created_at TIMESTAMPTZ DEFAULT NOW()
);
```

## Common errors

| Error | Cause | Fix |
|---|---|---|
| ECONNREFUSED | ssl: true | Set ssl: false |
| getaddrinfo failed | URL not parsed | Use the pgConfig() helper above |
| connection timeout | Pool not initialized | Move pool to top level (not inside handler) |