v1.0 general availability — Apache 2.0 licensed

Governed database access,
built for engineers.

AccessFlow is an open-source SQL proxy that sits between your team and your databases. Every query is parsed, classified, optionally AI-reviewed, and routed through a configurable human-approval workflow before it touches production — with a tamper-evident metadata audit trail of every decision.

PostgreSQL · MySQL · MariaDB · Oracle · MSSQL Self-hosted · SAML · OAuth · TOTP Anthropic · Ollama · OpenAI-compatible
~/accessflow — zsh
$ git clone github.com/bablsoft/accessflow
Cloning into 'accessflow'... done.
$ cd accessflow
$ docker compose up -d
[+] Running 4/4
postgres Healthy 12.3s
redis Started 1.4s
backend Started 6.1s
frontend Started 0.8s
Open http://localhost:5173 — the setup wizard creates the first admin
$
Architecture

One proxy. Every query. Zero shared credentials.

AccessFlow is the sole path between users and production databases. Customer-database credentials never leave the proxy — users authenticate to AccessFlow, the proxy holds the real JDBC connection pools and opens connections only after a query is approved.

CLIENT React SPA · /ws · REST
API GATEWAY Spring Boot 4 · JWT · Modulith
SERVICE Query Proxy
SERVICE Review Workflow
SERVICE AI Analyzer
SERVICE Admin & Audit
INTERNAL STATE PostgreSQL · Redis
CUSTOMER DATABASES (PROXIED) PostgreSQL · MySQL · MariaDB · Oracle · MSSQL · custom JDBC
Encryption AES-256-GCM for datasource credentials at rest. RSA-2048 JWT signing. SAML 2.0 keystore.
Runtime Java 25 with virtual threads. Horizontally scalable behind any L7 load balancer.
Observability Spring Boot Actuator probes. HMAC-SHA256 chained, append-only metadata audit log of every action.
Capabilities

The middle ground between blanket access and a DBA ticket queue.

Composable subsystems, configurable per datasource, observable end-to-end. Deployable inside your own infrastructure with no telemetry leaving the box.

Full SQL proxy

Every statement is parsed with JSqlParser, classified as SELECT / DML / DDL, validated against schema and table allow-lists at the AST level, then routed through your review policy before it touches the database.

PostgreSQL · MySQL · MariaDB · Oracle · MSSQL · custom JDBC

AI query analysis

Pluggable per-organization analyzer — Anthropic, Ollama, or any OpenAI-compatible backend. Every query gets a 0–100 risk score, missing-index detection, and anti-pattern flags before a human ever sees it.

Anthropic · Ollama · OpenAI-compatible

Configurable review workflows

Per-datasource approval chains with multi-stage reviewers, auto-approve reads, approval timeouts that auto-reject, and submitter cancellation. Reviewers are paged via Email, Slack Block Kit, or HMAC-signed webhooks.

State machine · Email · Slack · Webhooks

Workforce-ready auth

JWT RS256 with HttpOnly refresh-token rotation. SAML 2.0 SP- and IdP-initiated SSO with attribute-based role mapping. OAuth 2.0 / OIDC sign-in with built-in templates for Google, GitHub, Microsoft, and GitLab — plus optional TOTP 2FA.

JWT · SAML · OAuth · TOTP

Tamper-evident audit

Append-only metadata audit log chained with HMAC-SHA256. INSERT-only DB grants make after-the-fact rewrites detectable. CSV export, searchable UI, no row data ever stored.

HMAC-SHA256 chain

Cloud-native deploy

One docker compose up for local and small environments. Helm 3 chart for Kubernetes, with HPA, PDB, and Bitnami Postgres/Redis subcharts. Redis-backed distributed locks keep scheduled jobs safe across replicas.

Docker · Helm · Kubernetes · Modulith
Request flow

From keystroke to commit, observable at every step.

A single state machine drives every query through classification, review, and execution. Each transition is auditable, cancellable, and replayable.

SQL Editor History Saved datasource: prod-orders ⌄
1-- backfill missing region codes
2UPDATE orders
3 SET region_code = UPPER(substr(country, 1, 2))
4 WHERE region_code IS NULL
5 AND created_at > '2026-01-01';
5 lines · DML detected · review required Submit for review
Quick start

Up and governing queries in under five minutes.

Pick your platform. The backend runs Flyway migrations on first boot; the first admin is created through the in-app setup wizard the moment you open the SPA.

docker-compose.yml
# Zero-config demo — open http://localhost:5173 and follow the setup wizard.
# Demo-only JWT / encryption keys are embedded in the file; generate your own
# for anything beyond evaluation (see docs/09-deployment.md).
services:
  postgres:
    image: postgres:18
    environment:
      POSTGRES_DB: accessflow
      POSTGRES_USER: accessflow
      POSTGRES_PASSWORD: accessflow

  redis:
    image: redis:8-alpine

  backend:
    image: ghcr.io/bablsoft/accessflow-backend:latest
    depends_on: [postgres, redis]
    environment:
      DB_URL: jdbc:postgresql://postgres:5432/accessflow
      REDIS_URL: redis://redis:6379
      ENCRYPTION_KEY: # 64-char hex, demo default embedded
      JWT_PRIVATE_KEY: # PKCS#8 PEM, demo default embedded
    ports: ["8080:8080"]

  frontend:
    image: ghcr.io/bablsoft/accessflow-frontend:latest
    depends_on: [backend]
    ports: ["5173:80"]

System requirements

Backend
Java 25
Frontend
Node 24
Internal DB
PostgreSQL 18
Cache
Redis 8
Targets
PG · MySQL · MariaDB · Oracle · MSSQL
AI backends
Anthropic · Ollama · OpenAI-compat.
License
Apache 2.0
Roadmap

Shipped, shipping, and where we're going next.

Public, versioned milestones — driven by community input and adapter contributions. Full milestone scope lives in docs/12-roadmap.md.

v1.0

Core platform

  • SQL proxy · 5 DBs + custom JDBC
  • AI review · risk + index hints
  • Multi-stage approval workflows
  • JWT · SAML · OAuth · TOTP 2FA
  • HMAC-chained audit log
  • Docker Compose + Helm 3
v1.1

Productivity

  • Dynamic JDBC driver loading
  • Datasource creation wizard
  • Query scheduling
  • Bulk approval UI
  • AI analytics dashboard
  • User invitation flow
v1.2

Reviewer experience

  • Read replica routing
  • Query result diffing
  • Slack bot approve / reject
  • PagerDuty integration
  • Query templates library
  • Datasource health dashboard
v2.0

Beyond SQL

  • MongoDB query governance
  • Redis access governance
  • REST API governance
  • Custom analyzer plugin SPI
  • Column-level permissions
v2.1

Compliance

  • PII / PCI / PHI classification
  • Auto query suggestions
  • SOC2 / HIPAA report export

Stop choosing between speed and safety.

Pull the images, run docker compose up, point AccessFlow at your dev database, and watch a real query run through a real review workflow.