Skip to main content
A Data Source is a live connection from Supaboard to an external database or service. Every widget on a dashboard, every query run through Ask Stella, and every Agent’s knowledge of your data flows through these connections.

The Connections Page

Settings → Connections is the administrative home for all your data source connections. Each connection is shown as a card displaying:
  • The connector logo
  • The connection name
  • Table count (e.g. 5 tables)
Click any card to open its Connection Detail panel, which has tabs for Info, Tables, Summary, and Advanced settings. Search connections by name or connector type using the search bar.

The Data Source Browser

The Data Sources section in the main sidebar is the analyst-facing view — browse, explore, and interact with your connected data.

Filtering connections

FilterWhat it shows
AllEvery connection
ActiveConnected and ready to query
PendingConnected but currently syncing
FailedPreviously connected but now unreachable
Search across connections by name, connector type, or database.

View modes

Toggle between Card and List views.

Item actions

From any data source item’s action menu:
ActionDescription
OpenNavigate to the table browser for this connection
RenameChange the display name
FavouritePin to the top of the list
Ask StellaStart an AI conversation scoped to this connection
DeleteRemove the connection

Adding a Connection

Click New Connection from either the Connections page or the Data Source Browser. A searchable grid shows all available connectors — select one to open its configuration form.

Direct database connections

For databases (PostgreSQL, Snowflake, etc.), you connect directly by entering your host, credentials, and any advanced options (SSL, SSH tunnel). See Available Connectors for the full list.

Non-database connections via Fivetran

For SaaS tools and third-party services (Shopify, Google Analytics, Airtable, Stripe, and others), Supaboard uses Fivetran as the ETL layer. Fivetran handles syncing data from those services into a queryable form — you authenticate with the source service through Fivetran’s OAuth flow, and Supaboard takes care of the rest. Fivetran-powered connectors are available on the Business plan and above.

What happens after you save

  1. Supaboard creates the connection record.
  2. Tables in the database are discovered automatically.
  3. Schema generation runs in the background — column metadata is extracted for each table.
  4. The connection becomes queryable by agents and widgets once schema generation completes.
For large databases with many tables, schema generation runs as a background job. You can navigate away and return — the connection will show a Pending status until it’s ready.

Available Connectors

Direct database connectors — all plans

ConnectorNotes
PostgreSQLSupports SSH tunnel, SSL, JDBC params
MySQLSupports SSH tunnel, SSL, JDBC params
SnowflakeIncludes warehouse and schema auto-discovery
BigQueryOAuth or Service Account JSON authentication
Amazon RedshiftSupports SSH tunnel, SSL
MongoDBConnection string (URI) based
ClickHouse
DatabricksPersonal access token + HTTP path
SupabaseSSL on by default
Microsoft SQL ServerSupports SSH tunnel, SSL, JDBC params

Fivetran-powered connectors — Business & Enterprise plans

These connectors sync through Fivetran. Available integrations include: Shopify · Airtable · Stripe · Typeform · Calendly · Linear · Asana · YouTube Analytics · Notion · Auth0 · and more as Fivetran’s catalogue grows. Learn more about Fivetran-powered connectors here.

Testing a Connection

Every connector form has a Test Connection button in the footer. Click it before saving to verify that Supaboard can reach the database with the credentials provided.
  • On success: a toast confirms the database is responding.
  • On failure: the error message from the database is shown, helping you diagnose the issue (wrong password, firewall block, incorrect port, etc.).
Always test before saving. A saved connection that can’t connect will show as Failed and block agents and widgets that depend on it.

Connection Detail — Info Tab

Open any connection card to see the Info tab, which shows live diagnostics.

Performance metrics

  • Response time
  • Query latency
  • Connection pool stats

Security status

  • SSL/TLS enabled state
  • Encryption status
  • Authentication type

Connection pool (database connectors)

  • Active connections
  • Idle connections
  • Maximum pool size

Tunnel status (SSH tunnel connections)

  • Tunnel connection state
  • Tunnel latency

Database info

  • Database version, charset, and collation
  • Visible only to users with resource access

Warnings & errors

Any active warnings are listed. Errors are shown in a red alert box with details.

Connection Detail — Tables Tab

The Tables tab is where you manage which tables Supaboard knows about and what it knows about them.

Table list

Every table discovered in the database is listed here. For each table:
ActionWhat it does
Hide / ShowToggle whether this table appears in the data browser and is accessible to agents and widgets
Regenerate SchemaRe-scans this table’s columns and rebuilds its metadata
The footer shows a count of how many tables are currently hidden.

Missing schema banner

If any tables are missing schema (column metadata hasn’t been generated), a yellow banner appears at the top. Click Regenerate Schemas to rebuild all of them at once.
Schema generation polls in the background every 20 seconds. A loading overlay appears during bulk regeneration.

Remapping tables

Click Remap Tables to re-scan the database and discover any tables that have been added or removed since the connection was created. New tables are added to the list; removed tables are flagged.

Connection Detail — Summary Tab

The Summary tab holds a free-text description of the entire database — its purpose, what systems write to it, and any high-level context that helps Stella and your team understand what it contains. Write in plain language. This summary is read by agents when deciding whether and how to query this data source.

Connection Detail — Advanced Tab

The Advanced tab contains operations that modify or remove the connection.

Rename connection

Update the display name that appears across the UI, in agents, and in widget configurations.

Regenerate schema

Rebuilds schema metadata for all tables in this connection. Use this if your database structure has changed significantly (new columns added, types changed, tables restructured).
This operation is permanent and cannot be undone — existing schema metadata is replaced.

Delete connection

Permanently removes the connection from Supaboard. A confirmation is required. What happens on deletion:
  • The connection and its table metadata are removed.
  • Dashboards with widgets that queried this connection will show errors on those widgets.
  • Agents that included this connection in their scope lose access to it.
Deletion cannot be undone.

Team Access Control

By default, all workspace members can query any data source. You can restrict a specific connection to only certain team members. Open the connection’s Advanced tab and scroll to Team Access. Every non-deleted workspace member is listed with a toggle:
StateMeaning
Toggle onThis member can query this connection
Toggle offThis member cannot query this connection
Owner (locked on)Owners always have access and cannot be removed
Changes are saved automatically with a short debounce.

How this interacts with agent access

If a team member is blocked from a data source but an agent they use includes that source in its scope, the member will not be able to retrieve data from that source through the agent. The restriction is enforced at the connection level, regardless of agent configuration.

Schema Generation

Schema generation is the process of scanning a table’s columns, types, and relationships to build the metadata that agents use to write accurate queries.

When it runs

  • Automatically when a new connection is created.
  • On demand via the Regenerate button (per-table or bulk).
  • After remapping when new tables are discovered.

Schema statuses

StatusMeaning
GeneratedColumn metadata is complete and up to date
MissingSchema hasn’t been generated yet — agent queries against this table may be inaccurate
GeneratingSchema is currently being built (polls every 20 seconds)
Tables with missing schema are flagged in the Tables tab and in any Agent that includes them. Always resolve missing schemas before using a connection in production.

Database Context (Documentation)

Beyond raw schema, Supaboard lets you document what your data means at two levels: the whole database and individual tables. This context is read by agents to improve answer accuracy.

Database-level summary

Written in the Summary tab. A high-level overview of the database’s purpose and contents.

Table-level context

For each table in the Tables tab, you can fill in four fields:
FieldWhat to write
SummaryWhat this table stores and how it relates to other tables
GranularityWhat each row represents — e.g. “One row per invoice line item”
GotchasData quality issues, quirks, or caveats agents should be aware of
Use CasesCommon questions this table is useful for answering
Context written here is shared with any Agent that includes this data source. You do not need to re-enter it per agent — it flows through automatically.

Connection Statuses

StatusIndicatorMeaning
ActiveGreen dotConnected and ready to query
PendingSpinnerConnected; schema generation or sync in progress
FailedRed indicatorWas connected but is now unreachable — check credentials or network
DisconnectedGreyNo tables have been loaded yet
A failed connection will cause widgets and agents that depend on it to return errors. Open the connection’s Info tab to see the specific error message.

Egress IP Whitelist

If your database is behind a firewall, you need to allow inbound connections from Supaboard’s egress IPs. Navigate to any connector form and look for the Whitelist IPs section. The current list of Supaboard egress IP addresses is shown there — copy them and add them to your database’s firewall allow-list before attempting a connection.

Permissions

ActionMinimum role
View available data sourcesViewer (with resource access)
Browse tablesViewer (with resource access)
Create a connectionAdmin
Edit connection nameAdmin
Delete a connectionAdmin · Owner
Manage team accessOwner
Regenerate schemaAdmin
Remap tablesAdmin
Edit database / table contextAdmin
Test a connectionAdmin
Resource-level restrictions (set per connection) are enforced on top of workspace roles — a Viewer who has been blocked from a specific data source cannot query it regardless of other permissions.
Last modified on March 11, 2026