MongoDB - Mindsdb — ContextQMD

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:

Install MindsDB locally via Docker or Docker Desktop.

Connection

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

sql

CREATE DATABASE mongodb_datasource
WITH
  ENGINE = 'mongodb',
  PARAMETERS = {
    "host": "mongodb+srv://admin:[email protected]/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:

sql

SELECT *
FROM mongodb_datasource.my_collection
LIMIT 10;

<Note> The above examples utilize `mongodb_datasource` as the datasource name, which is defined in the `CREATE DATABASE` command. </Note> <Tip> At the moment, this integration only supports `SELECT` and `UPDATE` queries. </Tip>

Troubleshooting Guide

<Warning> `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. </Warning>

<Warning> `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.

</Warning> <Warning> `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`

</Warning>