Back to feed
Dev.to
Dev.to
7/16/2026
Let AI agents use production data without handing them your database

Let AI agents use production data without handing them your database

Short summary

Synapsor Runner is an Apache-2.0 runtime that sits between MCP clients and PostgreSQL/MySQL, exposing reviewed semantic capabilities instead of raw SQL to AI agents. The model can read only contract-allowed columns and rows, propose changes through a proposal-evidence-replay boundary, but never receives commit or write authority—all approvals and writebacks happen outside the model loop. Testing with injection-attack scenarios on real LLM agents showed zero cross-tenant reads and zero unauthorized writes, because enforcement lives server-side rather than relying on model compliance.

  • Exposes semantic capabilities (e.g., billing.inspect_invoice) instead of raw SQL to AI agents, eliminating model-facing write tools
  • Enforces tenant scope, allowed columns, and row limits via server-side contracts; proposals require external approval before any writeback
  • Testing with prompt-injection attacks yielded zero cross-tenant reads and zero unauthorized writes; also reduces token usage by avoiding schema dumps and SQL retry loops

Generated with AI, which can make mistakes.

Is this a good recommendation for you?

Comments

Failed to load comments. Please try again.

Explore more