For AI agents: a documentation index is available at https://www.mongodb.com/docs/llms.txt — markdown versions of all pages are available by appending .md to any URL path.
Docs Menu
Docs Home
/
Tools
/
SQL Interface
Docs Home
/
Tools
/
SQL Interface
Docs Home
/
Tools
/
SQL Interface

Install the MongoDB SQL Interface

The MongoDB SQL Interface lets you query your MongoDB data using standard SQL-based BI tools like Tableau, Power BI, and DBeaver.

To get started, use the following process:

1

Setup the server and schema.

Follow the instructions in Server Setup to configure your database to accept SQL connections. The setup process depends on your deployment type:

  • MongoDB Atlas: Connect to your cluster and let Atlas automatically configure the federated database instance in the background.

  • Enterprise Advanced (EA): Configure your self-managed database and generate a SQL schema for your collections using the MongoDB SQL Schema Builder CLI. To learn more, see the MongoDB SQL Schema Builder README.

2

Setup the driver.

Follow the instructions in Driver Setup to install the correct driver (JDBC or ODBC) on your client machine.

3

Connect your BI tool.

Follow the instructions in Connect Your BI Tool to configure your specific BI tool to connect to your MongoDB database.

Flow diagram showing MongoDB connecting to a BI tool through drivers and connectors.

Back

Migration Guide

Next

Server Setup

On this page