Does Rig support Azure SQL Database?

Yes. Both on-premise SQL Server and Azure SQL Database connect with a read-only login the same way.

Can Rig keep reporting off my production SQL Server?

Yes. Rig Ingest can replicate SQL Server into your warehouse so analytics queries run there.

Does Rig honour SQL Server permissions?

Yes. Rig connects read-only and inherited permissions apply, with Rig access controls layered on top.

Can I query SQL Server in an AI assistant?

Yes. Rig exposes SQL Server to Claude, ChatGPT, Cursor and other MCP clients for plain-English questions.

Warehouses & databases Supported

Microsoft SQL Server integration for Rig

The easiest way to query Microsoft SQL Server in Claude and other AI tools

Microsoft SQL Server is an enterprise relational database used for transactional and analytical workloads, including the managed Azure SQL Database service.

Try Rig Book a demo

What Rig sees in Microsoft SQL Server

Once connected, Rig models these objects so questions resolve to the right tables and joins:

Schemas and tables
Views
Foreign keys
Indexes
Stored procedures
Query statistics

How Microsoft SQL Server connects to Rig

Rig connects to SQL Server or Azure SQL with a read-only login and reads the catalog views to build a context layer over your tables and relationships. Rig Ingest can replicate SQL Server into your analytics warehouse for reporting at scale.

Query SQL Server data without T-SQL

Rig generates correct T-SQL from a plain-English question using your modelled schema and metric definitions. Finance and operations teams get the numbers they need without waiting on a report or learning the table layout.

Ask Rig

What was invoiced revenue last month by business unit?
Show open work orders by status from SQL Server
Which accounts are overdue on payment?

Replicate SQL Server into a cloud warehouse

Rig Ingest copies SQL Server tables into Snowflake, BigQuery or Redshift on a schedule, so analytics runs in the cloud warehouse and the operational database is left to serve the application. Schema changes are tracked.

Ask Rig

Sync the sales tables into the warehouse nightly
Has the schema of the orders table changed?
Build a margin report from the replicated SQL Server data

Work with Azure SQL the same way

Azure SQL Database connects identically to on-premise SQL Server. Rig reads the standard catalog views, so cloud and on-premise deployments behave the same in the context layer.

Ask Rig

Show monthly bookings from Azure SQL
Join customers to subscriptions in the Azure database
What is the renewal rate this year?

Ask SQL Server questions in Claude or ChatGPT

Rig serves SQL Server to AI assistants over MCP with read-only governance, so analysts can investigate enterprise data in the assistant they already use without write risk.

Ask Rig

Find customers with declining order volume
Pull the join from accounts to invoices
Explain how net revenue is calculated here

Ask your Microsoft SQL Server data in Claude, ChatGPT or Cursor

Rig serves your Microsoft SQL Server data to AI assistants over MCP. Once Microsoft SQL Server is synced into your warehouse, you can ask questions in plain English from the tool you already use, and every answer is backed by validated, governed SQL.

Frequently asked questions

Does Rig support Azure SQL Database?: Yes. Both on-premise SQL Server and Azure SQL Database connect with a read-only login the same way.
Can Rig keep reporting off my production SQL Server?: Yes. Rig Ingest can replicate SQL Server into your warehouse so analytics queries run there.
Does Rig honour SQL Server permissions?: Yes. Rig connects read-only and inherited permissions apply, with Rig access controls layered on top.
Can I query SQL Server in an AI assistant?: Yes. Rig exposes SQL Server to Claude, ChatGPT, Cursor and other MCP clients for plain-English questions.