PostgreSQL Integration
Updated Mar 29, 2026Integrations
Connect your Web App to a managed PostgreSQL database.
Overview
XAIO provides a fully managed PostgreSQL database for Web App projects. The database is automatically provisioned and connected to your backend.
Setup
- Open your Web App project
- Go to the Integrations tab
- Click PostgreSQL to enable
- XAIO creates a dedicated database with Dev and Prod environments
Database Browser
- Browse tables, columns, and data directly in the workspace
- Switch between Dev and Prod environments
- View data, run queries, and inspect schema
How it works
- Your backend connects via the DATABASE_URL environment variable
- XAIO automatically injects the connection string
- Dev and Prod databases are completely separate
- Schema migrations run automatically on publish
AI Integration
- The AI agent knows about your database schema
- Ask it to create tables, add columns, or write queries
- It generates proper migration files and backend code