Mongo-QL
Connect a Data Source
Description
MindsDB enables adding databases to your Mongo instance using the
db.databases.insertOne()
method.
Our MindsDB Mongo API supports creating a connection by passing the database credentials.
Syntax
Here is the syntax:
db.databases.insertOne({
name: "mongo_int",
engine: "mongodb",
connection_args: {
"port": 27017,
"host": "mongodb+srv://admin:@localhost",
"database": "test_data"
}
});
On execution, we get:
{
"acknowledged" : true,
"insertedId" : ObjectId("62dff63c6cc2fa93e1d7f12c")
}
Where:
Name | Description |
---|---|
name | Identifier for the data source to be created. |
engine | Database engine to be selected. |
connection_args | {"key":"value"} object storing the connection parameters such as port, host, database. |
Example
Here is an example of how to connect to the local MongoDB.
db.databases.insertOne({
name: "mongo_local",
engine: "mongodb",
connection_args: {
"port": 27017,
"host": "mongodb+srv://admin:@localhost",
"database": "test_data"
}
});
On execution, we get:
{
"acknowledged" : true,
"insertedId" : ObjectId("62dff63c6cc2fa93e1d7f12c")
}
You can list all the linked databases using the following command:
SHOW dbs;
On execution, we get:
+--------------------+
| Database |
+--------------------+
| admin |
| files |
| information_schema |
| mindsdb |
| mongo_int |
| views |
+--------------------+