Skip to main content

Documentation Index

Fetch the complete documentation index at: https://sourcetable.com/docs/llms.txt

Use this file to discover all available pages before exploring further.

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.