Introducción.

Quick Start

Vericto protects your databases by evaluating every SQL query against security rules before it reaches your data. Two integration modes — choose based on your use case:

Option A: TCP Proxy (PostgreSQL & MySQL)

Deploy a lightweight container in your infrastructure. Your app connects to the proxy instead of directly to the database — same credentials, different host. Available for PostgreSQL and MySQL, whose wire protocols the proxy speaks. For Oracle and SQL Server, use Option B.

# 1. Create account → Dashboard → Add Database → copy database_id
# 2. Deploy the proxy container
docker run -d --name vericto-proxy \
  -e VERICTO_API_URL=https://api.vericto.com \
  -e VERICTO_API_KEY=vtro_your_key \
  -e VERICTO_DATABASE_ID=your_database_id \
  -e UPSTREAM_PG_HOST=your-db-host \
  -e UPSTREAM_PG_PORT=5432 \
  -p 5433:5433 \
  ghcr.io/donkan168/vericto-proxy:latest

# 3. Update your app's connection string
DATABASE_URL=postgres://user:pass@<proxy-host-or-ip>:5433/mydb

Option B: HTTP API (all dialects — CI/CD & pipelines)

Evaluate queries via REST — no proxy deployment needed. Works for every dialect: PostgreSQL, MySQL, Oracle and SQL Server, and is the only integration path for Oracle and SQL Server. Ideal for validating migrations before deploy.

curl -X POST https://api.vericto.com/api/v1/proxy/query \
  -H "Authorization: Bearer vtro_your_key" \
  -H "Content-Type: application/json" \
  -d '{"query": "DROP TABLE users", "database_id": "your_db_id", "dialect": "postgres"}'

# → { "decision": "BLOCKED", "rule_code": "VERICTO-010" }

Architecture

Vericto uses deterministic AST (Abstract Syntax Tree) parsing to evaluate SQL queries. No AI, no probabilistic models, no false positives — the same input always produces the same result.

How it works

Your App → Vericto Proxy (your infrastructure, port 5433)
               │
               ├─ Parse SQL into full AST (pg_query for Postgres, sqlparser-rs for MySQL/Oracle/SQL Server)
               ├─ Evaluate AST against active security rules
               ├─ Resolve enforcement action (BLOCK / FLAG / MONITOR)
               │
               ├── SAFE? → Forward to your real database → relay response
               └── DESTRUCTIVE? → Return SQLSTATE 42501 (query never reaches DB)

Components

TCP Proxy (PostgreSQL & MySQL wire protocol)

The TCP proxy is a transparent interception layer. Any driver that uses the PostgreSQL or MySQL wire protocol works without code changes. Your database credentials never leave your infrastructure.

Zero stored credentials

Vericto never stores your database credentials or transmits them to Vericto Cloud. The proxy runs in your infrastructure and relays the PostgreSQL authentication exchange — the Authentication / PasswordMessage flow that follows the StartupMessage — straight through to your database. Your app connects to the proxy with the same user/password it would use to connect directly, and the credentials are verified by your database, not by Vericto. With SCRAM-SHA-256 (the modern PostgreSQL default) the password is never transmitted in cleartext at all; the proxy only relays the challenge-response.

Setup

Step 1: Create a database entry in the Vericto dashboard (Settings → Databases). You'll receive a database_id.

Step 2: Deploy the proxy container with these environment variables:

# Required — connects the proxy to the Vericto control plane
VERICTO_API_URL=https://api.vericto.com
VERICTO_API_KEY=vtro_xxxxxxxx            # from Dashboard → API Keys
VERICTO_DATABASE_ID=40eed96f-...         # from Dashboard → Databases

# Required — your real database (stays in your network)
UPSTREAM_PG_HOST=my-rds.amazonaws.com
UPSTREAM_PG_PORT=5432

# Proxy listener
PROXY_PG_LISTEN_PORT=5433

Step 3: Update your application's connection string to point to the proxy:

# Before (direct to DB)
DATABASE_URL=postgres://user:pass@my-rds.amazonaws.com:5432/mydb

# After (via Vericto proxy — same credentials, different host)
DATABASE_URL=postgres://user:pass@<proxy-host-or-ip>:5433/mydb

Docker Compose example

services:
  vericto-proxy:
    image: ghcr.io/donkan168/vericto-proxy:latest
    ports:
      - "5433:5433"
    environment:
      VERICTO_API_URL: "https://api.vericto.com"
      VERICTO_API_KEY: "${VERICTO_API_KEY}"
      VERICTO_DATABASE_ID: "${VERICTO_DATABASE_ID}"
      UPSTREAM_PG_HOST: "your-db-host"
      UPSTREAM_PG_PORT: "5432"
      PROXY_PG_LISTEN_PORT: "5433"

Optional configuration

# Telemetry buffering (default: memory)
VERICTO_TELEMETRY_BUFFER=memory          # or "disk" (survives restarts)
VERICTO_TELEMETRY_DISK_PATH=/var/lib/vericto/spool
VERICTO_TELEMETRY_BATCH_SIZE=100
VERICTO_TELEMETRY_FLUSH_SECS=5

# Rule sync interval (default: 300s)
VERICTO_RULES_SYNC_INTERVAL_SECS=300

# Upstream TLS — encrypt the proxy → database hop (default: disable)
UPSTREAM_PG_SSLMODE=require             # disable | require | verify-full
UPSTREAM_PG_SSLROOTCERT=/etc/vericto/rds-ca.pem   # CA bundle, only for verify-full
UPSTREAM_PG_SSLCERT=/etc/vericto/proxy-client.crt # optional: mutual TLS to the DB
UPSTREAM_PG_SSLKEY=/etc/vericto/proxy-client.key  # (cert auth, single service identity)

# Client TLS — terminate TLS on the app → proxy hop (default: disable)
PROXY_TLS_MODE=require                  # disable | require
PROXY_TLS_CERT=/etc/vericto/server.crt
PROXY_TLS_KEY=/etc/vericto/server.key

Wire protocol compatibility

Vericto operates as a fully transparent layer within the PostgreSQL wire protocol. The proxy automatically detects and evaluates SQL from both protocol modes — no configuration or driver changes required:

The proxy handles both modes transparently within the same connection. All other protocol traffic (authentication handshake, query results, server notifications, COPY operations) passes through unmodified. There is no configuration needed to select between modes — Vericto inspects each message's type byte and only intercepts SQL-carrying frames.

What Vericto evaluates (not just the obvious cases)

Because Vericto walks the full PostgreSQL AST (via libpg_query — the same parser the database uses), it catches destructive statements that surface-level / regex inspection misses:

• Multi-statement queries: every statement in a batch is parsed and evaluated, and the highest-severity violation wins. A destructive tail cannot hide behind a benign head — SELECT 1; DROP TABLE users; is blocked on the DROP.
• Data-modifying CTEs & subqueries: destructive operations nested inside WITH clauses or subqueries are detected — e.g. WITH x AS (DELETE FROM users RETURNING id) SELECT * FROM x.
• Parameterized statements: prepared statements are evaluated at Parse time on the query structure, so protection is deterministic regardless of the bound values.
• Injection tautologies: always-true predicates such as OR 1=1 in a WHERE clause are flagged as SQL-injection patterns.
• Multi-dialect: PostgreSQL, MySQL, Oracle and SQL Server are parsed with dialect-aware rules (e.g. MySQL DELETE … LIMIT is valid; Postgres has no such form). PostgreSQL and MySQL can run through the transparent proxy; Oracle and SQL Server are evaluated via the HTTP API.

TLS / Encryption

Proxy → database (upstream): set UPSTREAM_PG_SSLMODE to encrypt the hop to your database. Use require for encryption only, or verify-full to also validate the server certificate chain and hostname (provide the CA bundle via UPSTREAM_PG_SSLROOTCERT, or omit it to use the public CA roots). This is recommended whenever the database is remote (e.g. a managed RDS instance): the proxy performs the PostgreSQL SSLRequest negotiation and tunnels the session through TLS. To authenticate to a database that uses cert auth, set UPSTREAM_PG_SSLCERT + UPSTREAM_PG_SSLKEY — the proxy then presents that client certificate (one service identity) for mutual TLS.

Client → proxy: by default the proxy declines client TLS because it is designed to run inside the same trusted boundary as your application (sidecar, same host, or private subnet), where that hop never leaves your network. To encrypt it, set PROXY_TLS_MODE=require with PROXY_TLS_CERT + PROXY_TLS_KEY; the proxy answers the SSLRequest with 'S' and terminates TLS as the server. This is server-side TLS (the client authenticates the proxy).

When Vericto recommends terminating client TLS at the proxy:

• The app → proxy hop crosses an untrusted network (different host, VPC, or availability zone) rather than a sidecar / private subnet.
• Your driver enforces sslmode=require (or stricter) and you cannot or prefer not to put a TLS-terminating load balancer (AWS NLB, HAProxy) in front.
• A compliance baseline mandates encryption in transit on every hop.

If the proxy already runs as a sidecar or inside the same private subnet, this is unnecessary — leave it disabled. Inspecting SQL requires the connection to be decrypted at the proxy, so end-to-end TLS that the proxy cannot read is incompatible with query enforcement by design.

Authentication compatibility: the proxy relays the PostgreSQL authentication exchange end-to-end, so the common methods work unchanged — scram-sha-256, md5, cleartext password, and cloud token auth (AWS IAM, GCP IAM, Azure Entra). Two methods are not supported when the proxy terminates client TLS, by design: SCRAM channel binding (SCRAM-SHA-256-PLUS) and per-end-client cert auth — both bind authentication to the TLS channel specifically to detect a proxy in the middle.

Dashboard-managed settings (hot-reload)

The following proxy settings can be configured from the Vericto dashboard (Databases → Advanced Settings) and are applied automatically without restarting the proxy:

The proxy reads these settings from the /sync/rules response on every poll cycle. Changes take effect within one sync interval — no proxy restart required.

Note: TLS to your database (UPSTREAM_PG_SSLMODE and the CA certificate) is configured via environment variables in the proxy container, not the dashboard — it requires mounting a certificate file in your infrastructure.

Telemetry buffering: Memory vs Disk

The proxy buffers evaluation events before sending them to the Vericto API. Two strategies are available:

# Memory mode (default — zero config)
VERICTO_TELEMETRY_BUFFER=memory
VERICTO_TELEMETRY_MEMORY_CAPACITY=10000   # max events before ring drops oldest

# Disk mode (persistent — requires volume)
VERICTO_TELEMETRY_BUFFER=disk
VERICTO_TELEMETRY_DISK_PATH=/var/lib/vericto/spool

Resource recommendations

The proxy is designed to be lightweight. The AST engine is compiled to native code and evaluates queries in-process — no network calls on the hot path.

Key factors: CPU scales with query complexity (multi-JOIN queries take more AST nodes to parse). Memory scales with connection count (each TCP session holds ~4 KB state). Disk is only needed for disk-mode telemetry buffering.

Latency target: P99 < 2ms for rule evaluation. The proxy adds negligible overhead compared to network round-trip to your database.

HTTP API (alternative — no proxy deployment)

For CI/CD pipelines and pre-deploy checks, you can evaluate queries via REST without deploying the TCP proxy:

curl -X POST https://api.vericto.com/api/v1/proxy/query \
  -H "Authorization: Bearer vtro_xxxxxxxx" \
  -H "Content-Type: application/json" \
  -d '{
    "query": "DELETE FROM users WHERE id = 1",
    "database_id": "40eed96f-...",
    "dialect": "postgres"
  }'

# Response: { "decision": "BLOCKED", "rule_code": "VERICTO-001", ... }

Decisions & Actions

Vericto separates severity (how dangerous: Critical / High / Medium / Low / Informational) from enforcement action (what to do: BLOCK / FLAG / MONITOR). The action is resolved by the workspace's enforcement policy.

Default enforcement policy

Query telemetry & privacy

For every query it evaluates, the proxy emits a telemetry event to the Vericto API (status, severity, rule code, latency, and the query text). This powers the dashboard, metrics, and audit trail. Your database credentials are never part of telemetry — but the query text can contain sensitive values in its literals (e.g. WHERE email = 'alice@acme.com').

The query telemetry mode is configurable per workspace (Dashboard → Settings → Privacidad de la telemetría):

Sanitization is performed structurally on the parsed AST (for PostgreSQL via libpg_query's query normalization), so it is deterministic and does not rely on regular expressions. Example:

# raw
DELETE FROM users WHERE email = 'alice@acme.com' AND tenant_id = 42

# sanitized (what Vericto reports)
DELETE FROM users WHERE email = $1 AND tenant_id = $2

Recommendation: use sanitized for workspaces handling regulated or personal data (GDPR, HIPAA, Ley 1581 de 2012), and raw when full forensic fidelity in the audit trail is the priority and queries do not embed sensitive literals.

Authentication & HTTP Integration

All programmatic access to Vericto uses API keys. Create an API key from the dashboard (API Keys page) and include it in every request as a Bearer token.

Authorization: Bearer vtro_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

API keys are scoped to a workspace and inherit the workspace's plan limits. You can create multiple keys with different names for different environments (CI, staging, production).

Query evaluation endpoint

Request

{
  "query": "DELETE FROM users WHERE active = false",
  "database_id": "40eed96f-5602-41ef-807c-a4e821a8f4fa",
  "dialect": "postgres"
}

Response (BLOCKED)

{
  "decision": "BLOCKED",
  "rule_code": "VERICTO-001",
  "severity": "critical",
  "ast_node_path": "DeleteStmt > WhereClause = NULL",
  "suggested_safe_query": "DELETE FROM users WHERE active = false AND id = $1",
  "event_id": "uuid"
}

Response (ALLOWED)

{
  "decision": "ALLOWED",
  "rule_code": null,
  "severity": null,
  "latency_ms": 0.42,
  "event_id": "uuid"
}

Integration examples

curl -X POST https://api.vericto.com/api/v1/proxy/query \
  -H "Authorization: Bearer vtro_your_api_key" \
  -H "Content-Type: application/json" \
  -d '{
    "query": "DROP TABLE users",
    "database_id": "40eed96f-5602-41ef-807c-a4e821a8f4fa",
    "dialect": "postgres"
  }'

# Response (403):
# { "decision": "BLOCKED", "rule_code": "VERICTO-010", ... }

const response = await fetch('https://api.vericto.com/api/v1/proxy/query', {
  method: 'POST',
  headers: {
    'Authorization': 'Bearer vtro_your_api_key',
    'Content-Type': 'application/json',
  },
  body: JSON.stringify({
    query: 'UPDATE accounts SET balance = 0',
    database_id: '40eed96f-5602-41ef-807c-a4e821a8f4fa',
    dialect: 'postgres',
  }),
});

const { decision, rule_code, suggested_safe_query } = await response.json();

if (decision === 'BLOCKED') {
  console.error(`Query blocked by ${rule_code}`);
  process.exit(1);
}
console.log('Query is safe');

import requests
import sys

response = requests.post(
    "https://api.vericto.com/api/v1/proxy/query",
    headers={"Authorization": "Bearer vtro_your_api_key"},
    json={
        "query": "TRUNCATE TABLE orders",
        "database_id": "40eed96f-5602-41ef-807c-a4e821a8f4fa",
        "dialect": "postgres",
    },
)

data = response.json()
if data["decision"] == "BLOCKED":
    print(f"Blocked: {data['rule_code']} — {data['ast_node_path']}")
    sys.exit(1)
print("Query is safe")

import java.net.http.*;
import java.net.URI;

HttpClient client = HttpClient.newHttpClient();

String body = """
    {
      "query": "DELETE FROM users",
      "database_id": "40eed96f-5602-41ef-807c-a4e821a8f4fa",
      "dialect": "postgres"
    }
    """;

HttpRequest request = HttpRequest.newBuilder()
    .uri(URI.create("https://api.vericto.com/api/v1/proxy/query"))
    .header("Authorization", "Bearer vtro_your_api_key")
    .header("Content-Type", "application/json")
    .POST(HttpRequest.BodyPublishers.ofString(body))
    .build();

HttpResponse<String> response = client.send(request,
    HttpResponse.BodyHandlers.ofString());

if (response.statusCode() == 403) {
    System.err.println("Query BLOCKED: " + response.body());
    System.exit(1);
}
System.out.println("Query is safe");

using System.Net.Http.Json;

var client = new HttpClient();
client.DefaultRequestHeaders.Add("Authorization", "Bearer vtro_your_api_key");

var payload = new {
    query = "ALTER TABLE users DROP COLUMN email",
    database_id = "40eed96f-5602-41ef-807c-a4e821a8f4fa",
    dialect = "postgres"
};

var response = await client.PostAsJsonAsync(
    "https://api.vericto.com/api/v1/proxy/query", payload);

var result = await response.Content.ReadFromJsonAsync<VerictoResponse>();

if (result?.Decision == "BLOCKED")
{
    Console.Error.WriteLine($"Blocked: {result.RuleCode}");
    Environment.Exit(1);
}
Console.WriteLine("Query is safe");

record VerictoResponse(string Decision, string? RuleCode, string? AstNodePath);

# .github/workflows/vericto-check.yml
name: Vericto SQL Safety Check

on: [pull_request]

jobs:
  check-migrations:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v4

      - name: Check SQL migrations
        run: |
          for file in migrations/*.sql; do
            RESULT=$(curl -s -X POST https://api.vericto.com/api/v1/proxy/query \
              -H "Authorization: Bearer ${{ secrets.VERICTO_API_KEY }}" \
              -H "Content-Type: application/json" \
              -d "{\"query\": \"$(cat $file)\", \"database_id\": \"${{ vars.VERICTO_DB_ID }}\", \"dialect\": \"postgres\"}")

            DECISION=$(echo $RESULT | jq -r '.decision')
            if [ "$DECISION" = "BLOCKED" ]; then
              RULE=$(echo $RESULT | jq -r '.rule_code')
              echo "::error file=$file::Blocked by $RULE"
              exit 1
            fi
            echo "✓ $file — safe"
          done

# .gitlab-ci.yml
vericto-sql-check:
  stage: test
  image: curlimages/curl:latest
  script:
    - |
      for file in migrations/*.sql; do
        RESULT=$(curl -s -X POST https://api.vericto.com/api/v1/proxy/query \
          -H "Authorization: Bearer $VERICTO_API_KEY" \
          -H "Content-Type: application/json" \
          -d "{\"query\": \"$(cat $file)\", \"database_id\": \"$VERICTO_DB_ID\", \"dialect\": \"postgres\"}")

        DECISION=$(echo $RESULT | jq -r '.decision')
        if [ "$DECISION" = "BLOCKED" ]; then
          RULE=$(echo $RESULT | jq -r '.rule_code')
          echo "ERROR: $file blocked by $RULE"
          exit 1
        fi
        echo "✓ $file — safe"
      done
  rules:
    - if: $CI_PIPELINE_SOURCE == "merge_request_event"
      changes:
        - migrations/**/*.sql

# .circleci/config.yml
version: 2.1

jobs:
  vericto-sql-check:
    docker:
      - image: cimg/base:stable
    steps:
      - checkout
      - run:
          name: Check SQL migrations with Vericto
          command: |
            for file in migrations/*.sql; do
              RESULT=$(curl -s -X POST https://api.vericto.com/api/v1/proxy/query \
                -H "Authorization: Bearer $VERICTO_API_KEY" \
                -H "Content-Type: application/json" \
                -d "{\"query\": \"$(cat $file)\", \"database_id\": \"$VERICTO_DB_ID\", \"dialect\": \"postgres\"}")

              DECISION=$(echo $RESULT | jq -r '.decision')
              if [ "$DECISION" = "BLOCKED" ]; then
                RULE=$(echo $RESULT | jq -r '.rule_code')
                echo "ERROR: $file blocked by $RULE"
                exit 1
              fi
              echo "✓ $file — safe"
            done

workflows:
  check-on-pr:
    jobs:
      - vericto-sql-check:
          filters:
            branches:
              ignore: main

Response codes

Security Rules

See the complete list in the AST Rules Reference.

Error Codes

Plans & Limits