ANNOUNCEMENTVoyage AI joins MongoDB to power more accurate and trustworthy AI applications on Atlas. Learn more >
AnnouncementExplore Now: MongoDB MCP Server for AI-Powered Development (Public Preview) Read the blog >
NEWMongoDB 8.0: Experience unmatched speed and performance. Check it out >

ATLAS

Atlas SQL Interface

Easily query, analyze, and visualize Atlas data with SQL-based tools.

Get Started Now
An illustration showcasing real-time analytics, embedded metrics, and operational insights.

Query Atlas data with SQL

Atlas SQL Interface lets you query and analyze MongoDB data using familiar SQL syntax and tools. With its SQL-92 compatible MongoSQL dialect, you can seamlessly query Atlas clusters and cloud storage like S3 while simplifying schema management for analytics.

The suggested code demonstrates the ability to use a traditional SQL query with SQL Interface.
Highlights the connect modal and how users would connect to their BI tool.

Native BI tool integration

With Atlas SQL connectors and drivers, you can easily connect SQL-based BI and analytics tools to Atlas. Perform live analytics on operational data without complex ETL for faster, real-time insights.

Unified querying across data sources

Atlas SQL Interface leverages Atlas Data Federation to run distributed queries across live Atlas clusters and cloud storage. Analyze real-time and historical data seamlessly without moving or duplicating data.

Showcases the setup process for querying across clusters using Atlas Data Federation.

Run SQL natively on your Atlas data

Use the Atlas SQL Interface to query and join operational data in place, without the need for transformation or data movement.

Query operational data with familiar SQL

Use your existing SQL skills to access and join Atlas data across collections, clusters, and cloud storage. The Atlas SQL Interface supports a document-native SQL dialect with built-in schema abstraction, so you can analyze data where it lives using the tools you already know.

Read the documentation
Atlas CLI

Power dashboards with live Atlas data

Connect directly to your Atlas data from BI tools and apps, with no extracts or syncs. Use SQL to surface real-time metrics and KPIs in up-to-date dashboards.

SQL

Atlas SQL Interface customer successes

View all customers
Ganson Street logo
STREAMLINED REPORTING
“The old-school method of moving large data sets around takes time and effort. The Power BI Connector for Atlas creates a direct connection between our dashboards and our operational data, allowing us to find insights on the data we need in real time. This means faster, more informed decisions for our clients.”
Sam Marrazzo
Founder at Ganson Street
Ganson Street logo
STREAMLINED REPORTING
“The old-school method of moving large data sets around takes time and effort. The Power BI Connector for Atlas creates a direct connection between our dashboards and our operational data, allowing us to find insights on the data we need in real time. This means faster, more informed decisions for our clients.”
Sam Marrazzo
Founder at Ganson Street

Learning hub

Find tutorials, videos, and other resources on querying and analyzing your Atlas data with SQL.

FAQ

Get started with Atlas SQL Interface today

See how to quickly enable the Atlas SQL Interface and create a ready-to-use federated database mapped to your cluster data.
Get Started NowRegister now
GET STARTED TODAY
  • Easily connect BI tools to Atlas
  • Query live MongoDB data
  • No ETL required
  • Flexible setup with Data Federation