WEBINARHow to build smarter AI apps with Python and MongoDB. Register now >

NEWLearn MongoDB with expert tutorials and tips on our new Developer YouTube channel. Subscribe >

Atlas SQL Interface

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.

Now Available: SQL Interface for Enterprise Advanced

Query your MongoDB Enterprise Advanced data using familiar SQL syntax with the new SQL Schema Builder CLI.

Learn More

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

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

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
    }
  }
]

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

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

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

Read the documentation

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

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

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

Atlas SQL Interface

Now Available: SQL Interface for Enterprise Advanced

Query Atlas data with SQL

Native BI tool integration

Unified querying across data sources

Run SQL natively on your Atlas data

Atlas SQL Interface customer successes

Learning hub

FAQ

What is Atlas SQL Interface?

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

What is Atlas Data Federation?

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

How much does it cost to use Atlas SQL Interface?

Get started with Atlas SQL Interface today