Running schemagate as a service, IAM Access Control

Schemagate Agency Implementation, Secure Text-to-SQL Delivery

Learn how to deliver text-to-SQL solutions to clients while enforcing role-based schema visibility and reducing LLM token costs by 65-97%. This course covers identity-scoped schema restriction, hybrid retrieval ranking, and MCP client integration so your agency can build secure, cost-efficient AI query tools.

Open the decision record for schemagate

What does running schemagate for clients commit you to?

Published figures for this service. Blank fields are not published.

Monthly tool cost
Not published, schemagate is open-source with no listed pricing tiers; vendor cost is $0 for the library itself, and agency investment is labor for Python and database engineering setup.
Time to first value
Not published
Payback
Not modeled, client price, labor, usage, overhead, and expected volume are not supplied
Guided implementation
8 hours

Is schemagate worth running as a client service?

schemagate is a focused, open-source building block that solves identity-scoped schema selection and token reduction for text-to-SQL, with evidence of 65-97% token savings and high recall on test questions. The agency must supply its own client pricing, labor cost, and volume assumptions to model ROI, and the schemagate brand remains visible in delivery.

An agency-fit judgement for reselling this service. It is separate from the tool description on the decision record.

Before you start

What has to be in place before the first client engagement.

Tools and subscriptions

  • Python environment with pip (pip install schemagate)
  • SQLAlchemy-compatible database connection URL
  • MCP client setup (pip install 'schemagate[mcp]') for Cursor or Windsurf
  • API key for AI object descriptions via cat.describe()

People and inputs

  • Python and database engineering capacity to configure Principal objects and roles
  • Time to run the local studio against each client schema without data leaving the machine
  • Process for reviewing scoped DDL, hidden object list, and token savings report with clients

Included with the course

7 working documents for delivering this service.

  • Schema Visibility Audit Checklistchecklist
  • Role-Based Access Control Configuration Templatetemplate
  • Text-to-SQL Project Delivery SOPsop
  • Hybrid Retrieval Ranking Worksheetworksheet
  • Client Onboarding Guide for Cursor and Windsurf Integrationguide
  • Token Cost Reduction Calculatorworksheet
  • Local Studio Testing Protocolsop

Listed by name. These documents are not yet published as individual downloads.