This documentation describes the integration of MindsDB with MongoDB, a document database with the scalability and flexibility that you want with the querying and indexing that you need.

​
Prerequisites

Before proceeding, ensure the following prerequisites are met:

  1. Install MindsDB locally via Docker or Docker Desktop.

​
Connection

Establish a connection to MongoDB from MindsDB by executing the following SQL command:

CREATE DATABASE mongodb_datasource
WITH
  ENGINE = 'mongodb',
  PARAMETERS = {
    "host": "mongodb+srv://admin:admin_pass@demo.mongodb.net/public"
  };

Use the following parameters to establish the connection:

  • host: The connection string of the MongoDB server that includes user (admin), password (admin_pass), host and port (demo.mongodb.net), and database (public).
  • database: If the connection string does not include the /database path, provide it in this parameter.

Alternatively, the following set of connection parameters can be used:

  • username: The username associated with the database.
  • password: The password to authenticate your access.
  • host: The host of the MongoDB server.
  • port: The port through which TCP/IP connection is to be made.
  • database: The database name to be connected.

​
Usage

Retrieve data from a specified collection by providing the integration name and collection name:

SELECT *
FROM mongodb_datasource.my_collection
LIMIT 10;

The above examples utilize mongodb_datasource as the datasource name, which is defined in the CREATE DATABASE command.

At the moment, this integration only supports SELECT and UPDATE queries.

For this connection, we strongly suggest using the Mongo API instead of the SQL API.

MindsDB has a dedicated Mongo API that allows you to use the full power of the MindsDB platform. Using the Mongo API feels more natural for MongoDB users and allows you to use all the features of MindsDB.

You can find the instructions on how to connect MindsDB to MongoDB Compass or MongoDB Shell and proceed with the Mongo API documentation for further details.

Once you connected MindsDB to MongoDB Compass or MongoDB Shell, you can run this command to connect your database to MindsDB:

test> use mindsdb
mindsdb> db.databases.insertOne({
              name: "mongo_datasource",
              engine: "mongodb",
              connection_args: {
                      "host": "mongodb+srv://user:pass@db.xxxyyy.mongodb.net/"
              }
          });

Then you can query your data, like this:

mindsdb> use mongo_datasource
mongo_datasource> db.demo.find({}).limit(3)

​
Troubleshooting Guide

Database Connection Error

  • Symptoms: Failure to connect MindsDB with the MongoDB server.
  • Checklist:
    1. Make sure the MongoDB server is active.
    2. Confirm that host and credentials provided are correct. Try a direct MongoDB connection using a client like MongoDB Compass.
    3. Ensure a stable network between MindsDB and MongoDB. For example, if you are using MongoDB Atlas, ensure that the IP address of the machine running MindsDB is whitelisted.

Unknown statement

  • Symptoms: Errors related to the issuing of unsupported queries to MongoDB via the integration.
  • Checklist:
    1. Ensure the query is a SELECT or UPDATE query.

SQL statement cannot be parsed by mindsdb_sql

  • Symptoms: SQL queries failing or not recognizing collection names containing special characters.
  • Checklist:
    1. Ensure table names with special characters are enclosed in backticks.
    2. Examples:
      • Incorrect: SELECT * FROM integration.travel-data
      • Incorrect: SELECT * FROM integration.‘travel-data’
      • Correct: SELECT * FROM integration.`travel-data`