Integrations

Database Access for BI Tools

Generate read-only PostgreSQL credentials so you can connect external BI tools and SQL clients to your DevStride data.

Database Access lets you connect modern business intelligence (BI) tools—such as Metabase, Tableau, or Power BI—or any SQL client directly to your organization's DevStride data. You generate a set of read-only PostgreSQL credentials, plug them into your tool of choice, and build custom dashboards, cross-reference metrics, and generate insights beyond the reports built into DevStride.

Who can use this

Only organization Admins and Owners can manage Database Access. Every operation is enforced on the server, and the Organization Settings area itself isn't available to Members—so they never see the Database Access menu.

How it works

When you generate credentials, DevStride creates a dedicated read-only PostgreSQL role scoped to your organization. The connection points at a read replica of the database (not the live primary), so your queries never affect production performance. Access is limited to SELECT only, and row-level security policies keep every query isolated to your own organization's data.

Open Database Access

Open Organization Settings.
In the Organization section of the left settings rail, select Database Access (the database icon, listed below Permissions alongside Users and Teams).

The page header reads Manage Database Access.

Generate credentials

If no credentials exist yet, the page shows a Database Access card explaining that you can generate read-only database credentials to access your organization's data and connect using any SQL client or BI tool.

Select Generate Credentials. (The button shows Generating... while it works.)
DevStride creates a read-only role, a secure password, and the row-level security policies that scope access to your organization. The credential first appears as Pending and flips to Active once provisioning completes.
The Connection Details modal opens immediately so you can copy everything you need.

One credential set per organization

Each organization can have only one active set of credentials. If credentials already exist, generating new ones returns an error asking you to delete the existing credentials first. (A failed credential set is replaced automatically.)

Connection Details

The Connection Details modal gives you two ways to copy your connection information:

Quick Copy — a single, copyable Connection String for tools that accept a full connection URL.
Individual Fields — each parameter on its own, for tools that ask you to fill in fields:
- Database Type (postgresql)
- Host
- Port (defaults to 5432)
- Database
- Username
- Password (masked by default; reveal it on demand)
- Schema (always public)
- SSL (Enabled or Disabled)

The modal also suggests a display name for your BI tool, formatted as DevStride - {Your Organization Name}, with a Copy button so the connection is easy to recognize in your tool.

Your password is stored encrypted

The password is stored encrypted (AES-256-CBC) and can be re-revealed at any time by an Admin or Owner through View Details while the credential is Active. You don't need to capture it on first sight—but treat it like any other secret and only share it with people who should have access.

Manage existing credentials

Once a credential is active, the card shows the role name, a colored Status label, the date it was created, and a row of action buttons. The active section is titled Read-Only Database Access.

View Details (eye icon) — reopen the Connection Details modal to copy the connection string or reveal the password. This is available only while the credential status is Active.
Regenerate Credentials (sync icon) — rotate the password. The previous connection string stops working, so you'll need to update any tools that used it. DevStride warns you before regenerating.
Sync Tables — shown only when there are tables that haven't been synced yet.
Revoke Access (red) — disable the credential's ability to log in without deleting it. The status changes to Deactivated.
Activate Access — re-enable a revoked credential. This appears only when access has been deactivated.
Delete (red X) — remove the credential entirely. Deleting drops the PostgreSQL role, removes all associated policies and permissions, and deletes the credential record. This action cannot be undone.

Status values

As credentials are provisioned and managed, you may see any of these statuses:

Active — ready to use.
Pending — being provisioned.
Syncing — tables are being synced.
Failed — provisioning didn't complete; generating again replaces a failed credential.
Deleting — the credential is being removed.
Deactivated — access has been revoked (login disabled).

Security and scope

Read-only. Credentials are granted SELECT access only—they can't change your data.
Isolated to your organization. Row-level security policies key every query to your organization's data.
Read replica. Connections go to a read replica, not the primary database.
Admin/Owner only. Generating, viewing, regenerating, revoking, activating, syncing, and deleting credentials are all restricted to Admins and Owners.

GitHub

Connect AI & the MCP Server

Connect AI assistants like Claude, ChatGPT, Cursor, and Copilot to your DevStride workspace through the MCP server — now documented in its own section.

Jira Integration

Connect DevStride to Jira Cloud to import issues and keep work synchronized two ways.