---
title: "SQL Server: ask your database questions · Adea"
description: "Adea is built to read your Microsoft SQL Server database with a read-only login, so you can ask about sales and customers in plain words."
url: https://adea.app/integrations/sqlserver
---

# Ask your SQL Server database about sales, stock and customers.

Adea will read the tables you allow with a login that can only read, and answer in plain words with the query shown next to each answer.

[Tell us you need it](https://adea.app/contact) [Start free](https://adea.app/signup)

Microsoft SQL Server can't be connected yet

## What Adea reads from Microsoft SQL Server

- Tables and views in the databases you allow
- Orders, invoices and customers as your system stores them
- Counts and totals, read with plain SELECT queries
- A read replica or reporting copy, where you have one

## When it works

We're not ready to read from Microsoft SQL Server yet. Tell us you need it and we'll write to you the day it works.

[Tell us you need it](https://adea.app/contact)

## What you can ask

You ask

What was gross margin by product group last quarter?

Adea answers

Overall 41.2 percent. Accessories led at 58 percent on €96,400 in sales, while bikes sat at 33 percent on €412,000.

You ask

How many open orders are older than 14 days?

Adea answers

87 open orders, worth €31,950. 23 of them wait for the same supplier.

## Questions about Microsoft SQL Server

### What does Adea need to connect?

A SQL Server login with read rights only, on the databases you choose.

### Can Adea write to my system?

No. It only reads, and it never changes data or structure.

### Who sees customer details?

Only the people in your Adea workspace you give access to. What is shown follows the access you set.

## Coming from a BI tool on Microsoft SQL Server?

[Adea vs Metabase](https://adea.app/vs/metabase) [Adea vs Power BI](https://adea.app/vs/power-bi) [Adea vs Looker Studio](https://adea.app/vs/looker-studio) [Adea vs Tableau](https://adea.app/vs/tableau) [Adea vs Mode](https://adea.app/vs/mode) [Adea vs Hex](https://adea.app/vs/hex) [Adea vs Sigma](https://adea.app/vs/sigma) [Adea vs Omni](https://adea.app/vs/omni) [Adea vs ThoughtSpot](https://adea.app/vs/thoughtspot) [Adea vs Databox](https://adea.app/vs/databox)

## Other sources like this

[PostgreSQL](https://adea.app/integrations/postgres) [MySQL](https://adea.app/integrations/mysql) [MariaDB](https://adea.app/integrations/mariadb) [All sources](https://adea.app/integrations)

## What do you want to know?

- Which members haven't booked in 30 days?
- Why did revenue drop in Odense last week?
- How full were Monday's evening classes?
- What changed after the price increase?
- Who should we call about failed payments?

[Start free](https://adea.app/signup) [See the demo](https://adea.app/demo)

Connect a database, a shop or a spreadsheet. Your first numbers arrive in minutes.
