CREATE DATABASE
command.
The MindsDB SQL API supports creating connections to integrations by passing the
connection parameters specific per integration. You can find more in the
Supported Integrations chapter.
CREATE DATABASE
command.
Name | Description |
---|---|
datasource_name | Identifier for the data source to be created. |
engine_name | Engine to be selected depending on the database connection. |
PARAMETERS | {"key": "value"} object with the connection parameters specific for each engine. |
mindsdb
if not provided otherwise. That yields the
following SQL commands to result in the same output.port-number
.
localhost:5432
, use the following command:
4.tcp.ngrok.io:15093
instead of
localhost:5432
.
So to connect your local database to the MindsDB GUI, use the Forwarding
information. The host is 4.tcp.ngrok.io
, and the port is 15093
.
Proceed to create a database connection in the MindsDB GUI by executing the
CREATE DATABASE
statement with the host and port number obtained from
Ngrok.
DROP DATABASE
statement.
RETRAIN
your predictors, please ensure the database
connection has the same name you used when creating the predictor to avoid
failing to retrain.