Chat with your SQLServer data

AI to analyze SQLServer data with Claude and ChatGPT

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

SQLServer
You
What were total sales from SQLServer yesterday?
SQLServer
Yesterday's sales reached R$ 47.890 across 156 transactions with an average ticket of R$ 307.
Via Kondado MCP
You
Which product category has the highest inventory turnover?
Inventory
Electronics leads with 12.4x turnover this month, followed by apparel at 8.7x and home goods at 5.2x.
Via Kondado MCP
You
How many new customers did we acquire last week?
Customers
You acquired 234 new customers last week, representing a +18% increase compared to the previous 7-day period.
Via Kondado MCP
You
What is the current stock status for top-selling items?
Stock Status
23 items are below minimum stock levels, including your top 3 SKUs which need immediate replenishment.
Via Kondado MCP
Works in Claude, ChatGPT and any MCP client

AI to analyze SQLServer data with Claude and ChatGPT

Ask Claude, ChatGPT or any MCP client about your SQLServer data using natural language chat to uncover sales trends, track inventory KPIs, and compare operational metrics across periods. Instead of writing SQL queries manually, business teams can simply type questions about transaction volumes, customer records, or financial summaries and receive instant analytical answers. The AI reads your replicated SQLServer tables and views to deliver insights on demand, turning complex database structures into conversational intelligence.

Kondado replicates SQLServer data to make it accessible via MCP for analysis in Claude, ChatGPT, and other compatible clients. With 1 pipeline automatically mapping your database tables and views, you can query business metrics through chat while the same data powers ready dashboards in Power BI and Looker Studio.

Finance managers monitor cash flow and revenue recognition directly in chat without requesting IT reports, while operations teams track order fulfillment and stock levels by asking simple questions about their SQLServer records. Marketing analysts compare campaign performance against transactional data stored in the database, and e-commerce managers review customer behavior patterns by querying views that aggregate purchase history. Every department gains self-service access to Microsoft SQLServer insights through conversational AI, eliminating dependency on technical teams for routine data exploration.

I prefer ready dashboards

Dashboard templates in Power BI and Looker Studio, connected to your SQLServer data by Kondado in minutes.

View SQLServer dashboards →

I want to ask the AI

Claude, ChatGPT and other MCP clients query your SQLServer data in natural language.

View MCP setup →

The pipelines below expose your SQLServer database structure for AI querying. You can ask about sales performance using the Orders pipeline to calculate monthly revenue and average order values, explore customer segmentation through the Customers pipeline to identify high-value accounts, analyze stock turnover via the Inventory pipeline to prevent shortages, and review profit margins using the Products pipeline to optimize pricing strategies. The Transactions pipeline reveals payment patterns and cash flow timing, while joining the Orders and Customers pipelines enables cohort analysis and lifetime value calculations directly in chat. Combining multiple pipelines allows you to correlate marketing spend with actual sales recorded in SQLServer or match inventory levels against pending orders. With automated updates on a configurable schedule, your AI assistant always references the latest SQLServer records when answering questions about business performance.

How to connect SQLServer to Claude, ChatGPT and other AI clients

MCP is an open standard. Add the Kondado server to the connections of Claude (Web or Desktop), ChatGPT, or any other MCP client you use, and authorize via OAuth at app.kondado.com.br. Setup through the UI, no code.

Kondado MCP server: https://mcp.kondado.io/mcp
Detailed guide: Claude Detailed guide: ChatGPT
AI vocabulary

SQLServer tables and metrics available via Kondado

Each item below is something Claude, ChatGPT or another MCP client already knows how to query — no schema setup, no manual mapping.

1
Table
∞
Ad-hoc questions
Tabelas e Views
Kondado automatically maps all tables and views available in your database
Full docs on the wiki → Connect SQLServer now →

How to connect and use AI with your data

In 3 steps: connect on Kondado, pick dashboard or chat, analyze.

1
Connect SQLServer at Kondado

Connect your SQLServer database on Kondado at app.kondado.com.br and select a 'Via Kondado destination' so your data lands ready for AI access and for the dashboard templates.

2
Add Kondado MCP in AI settings

In Claude (Web or Desktop) or in ChatGPT, add the Kondado MCP server in the connection settings and authorize once via OAuth, using the same simple setup in both clients with no CLI or code needed.

3
Chat about data or open dashboards

Ask in chat using natural language about SQLServer data, and for visual recurring monitoring, open a ready Power BI or Looker Studio dashboard template.

Other connectors with AI via MCP

Same Kondado data, in chat through Claude, ChatGPT and other MCP clients.

CRM and Sales

ActiveCampaign ActiveCampaign
Bitrix24 CRM Bitrix24 CRM
Exact Sales Exact Sales
Hubspot Hubspot
Infusionsoft (Keap) Infusionsoft (Keap)
Meetime Meetime
NectarCRM NectarCRM
Pipedrive Pipedrive
PipeRun PipeRun
Ploomes Ploomes
RDStation CRM RDStation CRM
Salesforce Salesforce

Marketing and Automation

Google Ads Google Ads
E-goi E-goi
Google Search Console Google Search Console
Hi Platform Hi Platform
Huggy Huggy
Linkedin Linkedin
MailChimp MailChimp
Mandrill Mandrill
Mautic Mautic
Pushwoosh Pushwoosh
RDStation RDStation
Salesforce Marketing Cloud (Exact Target) Salesforce Marketing Cloud (Exact Target)
SenseData SenseData
Taboola Taboola
Twilio Twilio
WordPress WordPress

Advertising and Media

Apple App Store Apple App Store
Bing Bing
Criteo Criteo
Facebook Facebook
Facebook Ads Facebook Ads
Google Play Store Google Play Store
Instagram Ads Instagram Ads
Meta Ads Meta Ads
Microsoft Ads Microsoft Ads
Microsoft Advertising Microsoft Advertising
Pinterest Ads Pinterest Ads
TikTok Ads TikTok Ads
X Ads X Ads
YouTube YouTube

E-commerce and Marketplaces

Bling! Bling!
Hotmart Hotmart
Loja Integrada Loja Integrada
Mercado Libre Mercado Libre
Nuvemshop (Tiendanube) Nuvemshop (Tiendanube)
Olist Tiny Olist Tiny
Omie Omie
Pagar.me Pagar.me
Shopify Shopify
Tiny ERP Tiny ERP
Tray Tray
VNDA VNDA
VTEX VTEX
Wake Commerce Wake Commerce

Financial and Payments

ASAAS ASAAS
ContaAzul ContaAzul
Fatura Simples Fatura Simples
Granatum Granatum
Superlogica Superlogica
Sympla Sympla

Support and Customer Service

55pbx 55pbx
api4com api4com
Blip (take) Blip (take)
Clockify Clockify
EADBOX EADBOX
Freshdesk Freshdesk
Movidesk Movidesk
Recruiterbox Recruiterbox
Stilingue Stilingue
Wootric Wootric
Zendesk Zendesk
Zendesk Chat (Zopim) Zendesk Chat (Zopim)

Databases

AWS CloudWatch Metrics AWS CloudWatch Metrics
Azure Table Storage Azure Table Storage
BigQuery BigQuery
InfluxDB v1 InfluxDB v1
MongoDB MongoDB
MySQL (& MariaDB) MySQL (& MariaDB)
Oracle Oracle
PostgreSQL PostgreSQL
Webhook Webhook

Productivity and Collaboration

ClickUp ClickUp
Google Sheets Google Sheets
Jira Jira
monday.com monday.com
Notion Notion
Pipefy Pipefy
Tangerino Tangerino
Toggl Toggl
Trello Trello

Social Media

Instagram Instagram
TikTok Organic TikTok Organic

User Analytics

Google Analytics GA4 Google Analytics GA4
Mixpanel Mixpanel
Zeeng Zeeng

Storage and Transfer

Amazon S3 Amazon S3
FTP FTP
Google Cloud Storage Google Cloud Storage
See all AI connectors →

Related on Kondado

Frequently asked questions about AI

How ready dashboards and chat via Claude / ChatGPT work together with your data via Kondado.

What business questions can Claude or ChatGPT answer about my SQLServer data in chat? ▼
Claude and ChatGPT can analyze sales trends, calculate inventory turnover, compare quarterly revenue across regions, and identify top-performing product categories by querying your SQLServer tables. The AI interprets natural language questions about transaction volumes, customer counts, and operational metrics, returning specific numbers and insights without requiring SQL knowledge.
How do I configure Claude or ChatGPT to access my SQLServer data through Kondado? ▼
Open the connection settings in Claude (Web or Desktop) or ChatGPT, add the Kondado MCP server, and complete the OAuth authorization at app.kondado.com.br to grant read access. This GUI-based setup requires no command line tools or JSON configuration, working identically across both AI clients and other MCP clients.
Does the AI write data back to my SQLServer database or execute actions? ▼
No, the MCP connection provides read-only analytical access, allowing Claude and ChatGPT to query and analyze your SQLServer data but never to modify, delete, or insert records. This ensures your database remains unchanged while enabling safe exploration of business metrics through chat.
How does authentication work when connecting SQLServer to AI clients? ▼
You authorize the connection once via OAuth at app.kondado.com.br, granting the MCP server permission to read your replicated SQLServer data. This single sign-on process eliminates the need for API keys or complex credential management within Claude or ChatGPT.
How frequently does the SQLServer data update for AI queries? ▼
Kondado replicates your SQLServer data on a configurable schedule, ensuring Claude and ChatGPT reference near-real-time information when answering questions. You control the sync timing based on your business needs, from hourly updates for operational monitoring to daily snapshots for trend analysis.
What dashboard templates are available for visual monitoring of SQLServer data? ▼
Kondado offers ready report templates in Power BI and Looker Studio that visualize the same SQLServer data available through AI chat, including sales performance, inventory levels, and financial summaries. These dashboards provide recurring visual monitoring while the AI handles ad-hoc analytical questions.
What is the difference between asking the AI about SQLServer data and opening a ready dashboard? ▼
Chat-based analysis with Claude or ChatGPT answers specific, on-demand questions using natural language, such as "What were sales last Tuesday?", while ready dashboards in Power BI or Looker Studio display predefined visual reports for recurring KPI monitoring. The AI excels at exploratory investigation, whereas dashboards maintain consistent visual tracking of standard metrics.

Try out all the features for free for 14 days