SQL SERVER
Talk to your SQL Server in plain English
Self-hosted text-to-SQL for Microsoft SQL Server. Read-only, governed, runs in your infrastructure.
Connect in one step
Ask in plain English
Real SQL Server queries Limerence generates from business questions.
“Pipeline coverage by stage for the current quarter”
SELECT stage,
COUNT(*) AS deal_count,
SUM(amount) AS total_amount,
AVG(amount) AS avg_deal_size
FROM opportunities
WHERE close_date >= DATEFROMPARTS(YEAR(GETDATE()), ((MONTH(GETDATE()) - 1) / 3) * 3 + 1, 1)
AND status = 'open'
GROUP BY stage
ORDER BY total_amount DESC;“Parse webhook payloads from the events.payload JSON column”
SELECT e.id, e.received_at, p.event_type, p.user_id, p.metadata
FROM events e
CROSS APPLY OPENJSON(e.payload)
WITH (
event_type NVARCHAR(64) '$.type',
user_id BIGINT '$.user.id',
metadata NVARCHAR(MAX) '$.metadata' AS JSON
) AS p
WHERE e.received_at >= DATEADD(DAY, -7, GETDATE());“Top 5 most recent orders for each customer”
SELECT c.id, c.name, o.order_id, o.total, o.created_at
FROM customers c
CROSS APPLY (
SELECT TOP 5 order_id, total, created_at
FROM orders
WHERE customer_id = c.id
ORDER BY created_at DESC
) AS o
ORDER BY c.id, o.created_at DESC;How it works with SQL Server
- Connects via the tedious driver over the TDS protocol.
- Schema discovery uses INFORMATION_SCHEMA plus the sys catalog views.
- Compatible with SQL Server 2017, 2019, 2022, Azure SQL Database, and Managed Instance.
- OPENJSON, CROSS APPLY, MERGE, and window functions are all available in generated SQL.
- Three-part names and linked servers are usable when the connection role permits.
SQL Server questions
Does this work with Azure SQL?+
Yes. Azure SQL Database and Managed Instance both connect over the standard TDS protocol with the credentials you provide.
SQL Authentication or Windows Authentication?+
Both supported via tedious. SQL Auth is the simplest; Windows Auth uses NTLM/Kerberos depending on environment.
What happens with Always Encrypted columns?+
They appear as encrypted in schema discovery. The agent will not attempt to decrypt them in generated queries — that is by design.
Can the agent use linked servers?+
Yes, if the connection role has permission. Linked-server objects show up in schema discovery as four-part names.
Only your schema structure (table and column names, types) is shared with the LLM. Row data is never sent. Generated SQL runs against your database directly and results stay inside your network.