New · SOFI private deployment is ready for enterprise rolloutTalk to us→
SOFI
[ QUICKSTART ][ SDK REF ][ SQL ][ MCP ]
endpoint · /docs

Documentation,end to end

From a 15-minute quickstart to architecture deep-dives. SDKs, REST, SQL, MCP, JDBC — and the concepts behind each one. Search, copy-paste, ship.

Open full docsTalk to sales
[ 01 / 04 ]Quickstart
// Quickstart //

Ship your first view

Three on-ramps, depending on whether you write SQL, drag boxes, or run on-prem.

Quickstart

Connect three sources, model a view, attach a policy and publish to SQL + REST in under 15 minutes.

First view in Studio

Drag a Postgres source onto the canvas, attach a masking policy, ship the published view to Looker.

Beta

Self-host install

Air-gapped install via terraform + helm. Includes architect rollout and disaster-recovery topology.

[ 02 / 04 ]SDKs
// SDKs //

Drive SOFI from your stack

Typed clients for Python and Node.js. SDK for building custom connectors when ours don't fit.

Python SDK

pip install sofi · async client · typed schemas · streaming results · MCP server bindings.

Node.js SDK

npm i @sofi/sdk · TypeScript-first · ESM + CJS · works in Cloudflare Workers and Vercel.

Beta

Custom connector SDK

Build connectors for proprietary engines. Ships with test harness, schema scanner and pushdown helpers.

[ 03 / 04 ]Endpoints
// Endpoints //

Four protocols, one surface

Every governed view is reachable across all four channels — same RBAC, same masking, same audit log.

REST API

OpenAPI 3.1 spec. Per-view endpoints, signed responses, pagination, streaming.

SQL endpoint (pgwire)

PostgreSQL wire protocol on port 5556. Connect any client that speaks Postgres — psql, JDBC, BI tools.

MCP for AI

Model Context Protocol server. Every governed view becomes an MCP tool with typed args, RBAC and audit.

JDBC / ODBC drivers

Driver bundles for Java and ODBC tooling. Same governed surface as pgwire — different protocol.

[ 04 / 04 ]Concepts
// Concepts //

The model behind the surface

Read these once and the SDK / REST / SQL pages all click into place. Useful for architects evaluating SOFI.

Federation

How SQLGlot rewrites queries, how DuckDB stitches federation, how predicate pushdown works engine by engine.

Governance

RBAC roles, masking policies, consent gates, audit retention and lineage propagation.

Lineage & DSR

Column-level lineage, DSR (data subject request) export, DPIA and RoPA templates.

Architecture

Internal architecture: API, engine, catalog, governance and pgwire. Useful for self-host operators.

// cmd-K to search

Search docs across every page.

The docs site supports full-text search and code-aware navigation. Or open an issue on GitHub if a page is missing.

Talk to salesEnterprise pricing