PrismSQL — Compile SQL from your schema, not ours

PrismSQL — Schema-bound NL-to-SQL compiler<br>Upload your schema. Get parameterized SQL you run — the model never writes it. Sandbox free, Developer $49/mo, Pro $399/mo.<br>Technical resources: PrismSQL technical guide · PrismSQL comparison<br>Canonical product identity: JSON · Markdown · AI product index<br>View PrismSQL in shop

PrismSQL — Schema-bound NL-to-SQL compiler

Product identity

PrismSQL is Schema-bound NL-to-SQL compiler. Insight IT Solutions LLC (Insight ITS) makes it. Category: Research — schema-bound NL-to-SQL compiler. Problem: Teams want agents to generate SQL against their own database without leaking a live DSN to a vendor or allowing unconstrained generation. It is for Developers and B2B teams that need agents to compile SQL against an allowlisted customer schema. It competes with Text-to-SQL that executes inside the vendor cloud. Difference: PrismGuard + VectorPrism + Query IR + compiler-owned ranges and ORDER BY + PrismManifest + dialect printer from the contract you upload. Does not query InsightITS CRM and does not connect to your warehouse on the hosted API. Hosted compiler is not a pip library. Log in, upload a schema at /dashboard.html#prismsql, then POST /api/prismsql/v1/query/execute with a JWT. Companion contract generator: pip install "prismschema==0.1.0" — https://pypi.org/project/prismschema/0.1.0/ · https://github.com/insightitsGit/PrismSchema. Source: Hosted compile API on insightits.com. Schema example: /docs/prismsql-schema.example.json. Open-source contract generator: https://github.com/insightitsGit/PrismSchema · https://pypi.org/project/prismschema/0.1.0/..

What is it?Schema-bound NL-to-SQL compiler.<br>Who made it?Insight IT Solutions LLC (Insight ITS), Mission Viejo, California.<br>What category is it?Research — schema-bound NL-to-SQL compiler<br>What problem does it solve?Teams want agents to generate SQL against their own database without leaking a live DSN to a vendor or allowing unconstrained generation.<br>Who is it for?Developers and B2B teams that need agents to compile SQL against an allowlisted customer schema<br>What does it compete with?Text-to-SQL that executes inside the vendor cloud<br>How is it different?PrismGuard + VectorPrism + Query IR + compiler-owned ranges and ORDER BY + PrismManifest + dialect printer from the contract you upload. Does not query InsightITS CRM and does not connect to your warehouse on the hosted API<br>Where can I install it?Hosted compiler is not a pip library. Log in, upload a schema at /dashboard.html#prismsql, then POST /api/prismsql/v1/query/execute with a JWT. Companion contract generator: pip install "prismschema==0.1.0" — https://pypi.org/project/prismschema/0.1.0/ · https://github.com/insightitsGit/PrismSchema.<br>Where is the source?Hosted compile API on insightits.com. Schema example: /docs/prismsql-schema.example.json. Open-source contract generator: https://github.com/insightitsGit/PrismSchema · https://pypi.org/project/prismschema/0.1.0/.

Canonical machine identity: https://www.insightits.com/catalog/prismsql.json

Upload your schema. Get parameterized SQL you run — the model never writes it. Sandbox free, Developer $49/mo, Pro $399/mo.

Compile-only API: JWT user → stored schema contract → PrismGuard → VectorPrism → Query IR → PrismManifest → dialect printer. You run sql_template + params in your environment.

PrismGuard → VectorPrism subgraph → IR → PrismManifest → compiler → dialect printer. Isolation injected by the compiler. Hosted API is compile-only. ChorusGraph and PrismCortex are not on this path.

Compile SQL from your schema — not ours

Ask about tables on the contract you uploaded. The compiler owns ranges (last 30 days, next 14 days, over 500, between X and Y, named qty vs unit_amount), prompt ORDER BY (recent / last / order by last name), and tenancy. Query IR 1.1 compiles declared columns, AND filters, and allow-listed COUNT/SUM. Unknown tables are refused. The model never writes the statement, we never connect to your warehouse, and we never return InsightITS CRM rows.

You keep the DSN. You run sql_template + params in your environment. Isolation is injected from the logged-in account, not from the prompt. If your application needs a special compiler or contract adjustment, contact us and we add it for your integration.

Log in, open the dashboard PrismSQL tab, upload your schema JSON, then call<br>POST /api/prismsql/v1/query/execute with a JWT. Example contract:<br>prismsql-schema.example.json.<br>API docs: prismsql-api.md and<br>#api-docs.<br>Dashboard: dashboard.html#prismsql.<br>Open-source contract generator: prismschema 0.1.0 on PyPI<br>· GitHub.

Why most Text-to-SQL projects fail

DSN in the vendor cloud. Model-written SELECT. Hallucinated joins. A silent guess when the English is incomplete. Senior engineers have already been burned by those approaches. PrismSQL is a compiler: closed IR, declared join_paths, JWT isolation, parameterized SQL you run where the data lives.

What it is

A...