PostgreSQL

Import tables from any PostgreSQL database. Enter your host, port, database, user, and password. Auto-discover tables and sync data to your workspace.

Start Using PostgreSQL

How It Works

Bring your PostgreSQL data into your Flashbox workspace with our built-in connector. Enter your connection details (host, port, database, user, password), and Flashbox auto-discovers all tables in the public schema. Select which tables to import and data syncs automatically to your workspace. Works with any PostgreSQL-compatible database including Supabase, Neon, Railway, AWS RDS, and more.

Setting up PostgreSQL access

Gather your connection details

You'll need your PostgreSQL host (e.g. "db.example.com" or "localhost"), port (default 5432), database name, username, and password. If your database is hosted in the cloud (AWS RDS, Neon, Supabase, Railway, etc.), find these in your provider's dashboard.

Ensure network access

Make sure your PostgreSQL server accepts connections from Flashbox. For cloud-hosted databases, you may need to whitelist Flashbox IPs (74.220.49.0/24, 74.220.57.0/24) in your firewall or security group settings.

Use a read-only user (recommended)

For security, create a dedicated read-only PostgreSQL user for Flashbox: CREATE USER flashbox WITH PASSWORD 'your_password'; GRANT CONNECT ON DATABASE your_db TO flashbox; GRANT USAGE ON SCHEMA public TO flashbox; GRANT SELECT ON ALL TABLES IN SCHEMA public TO flashbox; This ensures Flashbox can only read data, never modify it.

Enter credentials in Flashbox

Enter your host, port, database, user, and password when prompted. If your database requires SSL (most cloud-hosted databases do), enable the SSL toggle. Flashbox will connect and automatically discover all tables in the public schema.

Select tables to import

Choose which tables you want to import from the discovered list. Click "Import" on each table - the entire table will sync to your workspace on your schedule. Use the "Refresh" button to refetch the table list if needed.

Features

Simple credential-based setup (host, port, database, user, password)
Auto-discover all tables in the public schema
Optional SSL for secure connections
Full table sync to workspace
Scheduled sync keeps data fresh
Works with Supabase, Neon, Railway, AWS RDS, and more

Use Cases

Application database analytics
SaaS product metrics
User and customer insights
Operational reporting

Prefer a custom integration?

While we offer a built-in connector for PostgreSQL, you can also ask our AI agent to build a custom integration tailored to your specific needs. This gives you full control over what data to fetch and how to transform it. Learn about custom AI integrations →

Ready to bring your PostgreSQL data into Flashbox?

Start for free and connect in 1-click with our built-in connector.

Get Started Free

MySQL

Notion