Skip to main content
Sourcetable connects to 25 database types across all major cloud providers. Query your databases directly from the spreadsheet and bring live data into your analysis.

​
Supported databases

​
PostgreSQL

  • PostgreSQL (generic)
  • AWS Aurora PostgreSQL
  • AWS RDS PostgreSQL
  • Azure PostgreSQL
  • Google Cloud PostgreSQL
  • Heroku PostgreSQL
  • Supabase

​
MySQL

  • MySQL (generic)
  • AWS Aurora MySQL
  • AWS RDS MySQL
  • Azure MySQL
  • Google Cloud MySQL

​
MariaDB

  • MariaDB (generic)
  • AWS RDS MariaDB
  • Azure MariaDB

​
Microsoft SQL Server

  • SQL Server (generic)
  • Azure SQL
  • AWS RDS SQL Server

​
MongoDB

  • MongoDB
  • MongoDB Sharded Cluster

​
Other

  • Snowflake
  • AWS DynamoDB
  • Azure Cosmos DB
  • Magento (MySQL-based)

​
Connecting a database

1

Add a connector

Click Add Connector > Database and select your database type.
2

Enter credentials

Provide your connection details:
  • Host — the database server address
  • Port — the connection port (defaults are pre-filled)
  • Database — the database name
  • Username — your database user
  • Password — your database password
Or paste a connection string if you have one.
3

Test and connect

Sourcetable tests the connection and displays available tables and views.
4

Select tables

Choose which tables to make available in your spreadsheet. You can query them using the SQL editor or ask the AI to pull data.

​
Querying connected databases

Once connected, you can:
  • Use the SQL editor to write queries directly against your database
  • Ask the AI assistant to query in natural language: “Show me all customers who signed up last month”
  • Use the query builder for a visual, no-code approach
  • Save queries to the data library for reuse

​
Security

  • Connections are encrypted in transit (TLS/SSL)
  • Credentials are encrypted at rest
  • Sourcetable never stores your raw database data — it streams results on demand
  • Enterprise plans support VPC peering and IP whitelisting
Database connectors are available on Pro, Max, and Enterprise plans.