Atlas SQL Interface

ATLAS

Atlas SQL Interface

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

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.

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.

Run SQL natively on your Atlas data

View Documentation

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

View Documentation

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

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.

Query operational data with familiar SQL

Read the documentation

Atlas CLI

Code Snippet

AtlasDataFederation test> use Supplies
switched to db Supplies

AtlasDataFederation Supplies> db.sql("select * from Sales limit 1")
Note: this is an experimental feature that may be subject to change in future releases.

[
  {
    Sales: {
      _id: ObjectId("5bd761dcae323e45a93ccff4"),
      saleDate: ISODate("2014-08-18T10:42:13.935Z"),
      items: [
        {
          name: "backpack",
          tags: ["school", "travel", "kids"],
          price: Decimal128("187.16"),
          quantity: 2
        },
        {
          name: "printer paper",
          tags: ["office", "stationary"],
          price: Decimal128("20.61"),
          quantity: 10
        },
        {
          name: "notepad",
          tags: ["office", "writing", "school"],
          price: Decimal128("23.75"),
          quantity: 5
        },
        {
          name: "envelopes",
          tags: ["stationary", "office", "general"],
          price: Decimal128("9.44"),
          quantity: 5
        }
      ],
      storeLocation: "San Diego",
      customer: {
        gender: "F",
        age: 59,
        email: "la@cevam.tj",
        satisfaction: 4
      },
      couponUsed: false
    }
  }
]

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

Code Snippet

Atlas CLI

Code Snippet

AtlasDataFederation test> use Supplies
switched to db Supplies

AtlasDataFederation Supplies> db.sql("select * from Sales limit 1")
Note: this is an experimental feature that may be subject to change in future releases.

Atlas SQL Interface customer successes

View all customers

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

STREAMLINED REPORTING

Sam Marrazzo
Founder at Ganson Street

Learning hub

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

FAQ

What is Atlas SQL Interface?

The Atlas SQL Interface allows you to connect SQL-based business intelligence and analytics tools to Atlas and query your MongoDB data using native SQL syntax. This makes it easy to uncover insights faster on live application data using the tools you already know.

Read the documentation

Does Atlas SQL Interface support BI tools like Tableau and Power BI?

With Atlas SQL connectors and drivers, you can connect BI tools directly to your data for seamless analysis and visualization.

Read the documentation

What is Atlas Data Federation?

Atlas Data Federation lets you create virtual databases that span multiple clusters, storage layers, and sources. It powers the SQL Interface by providing a unified view of your data without requiring any additional ETL.

Learn more about Atlas Data Federation

What other tools or connectors are available to integrate MongoDB into my stack?

MongoDB offers official connectors for popular tools and platforms, including Kafka, Spark, Kubernetes, and more. These integrations support real-time streaming, data transformation, and analytics workflows.

Learn more

How much does it cost to use Atlas SQL Interface?

There is no cost to enable the Atlas SQL Interface or to download and use the official drivers and connectors. Usage is based on the volume of data processed via Atlas Data Federation, with pricing based on scanned data and standard cloud provider transfer rates.

Learn more

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