MindsDB Tables Structure¶
MindsDB Default Tables¶
On start-up, the MindsDB database consists of 2 tables: predictors and databases.
You can verify it by running the following SQL command:
SHOW tables;
On execution, we get:
+----------------------+
| Tables_in_mindsdb |
+----------------------+
| predictors |
| databases |
+----------------------+
The predictors Table¶
At first, the predictors table is empty. But, as soon as you create your first machine learning model, you'll see it as a new record in the predictors table.
SELECT *
FROM mindsdb.predictors;
On execution, we get:
+-------+---------+-----------+----------+----------------+------------------+--------+--------------------+-------------------+
|name |status |accuracy |predict |update_status |mindsdb_version |error |select_data_query |training_options |
+-------+---------+-----------+----------+----------------+------------------+--------+--------------------+-------------------+
| | | | | | | | | |
+-------+---------+-----------+----------+----------------+------------------+--------+--------------------+-------------------+
Where:
| Column name | Description |
|---|---|
name |
The name of the ML model. |
status |
Training status having one of the values: generating, training, complete, error. |
accuracy |
The accuracy of the ML model. |
predict |
The name of the target variable column to be predicted. |
update_status |
Training update status (up_to_date or updating). |
mindsdb_version |
The version of MindsDB under which this ML model was created. |
error |
In the case of an error, it contains an error message. |
select_data_query |
SQL select query to create the datasource. |
training options |
Additional training parameters. |
Example¶
To create a predictor, follow this guide.
SELECT *
FROM mindsdb.predictors;
On execution, we get:
+-----------------+--------+------------------+-------+-------------+---------------+-----+-----------------+----------------+
|name |status |accuracy |predict|update_status|mindsdb_version|error|select_data_query|training_options|
+-----------------+--------+------------------+-------+-------------+---------------+-----+-----------------+----------------+
|house_sales_model|complete|0.4658770134240238|ma |up_to_date |22.7.5.1 | | | |
+-----------------+--------+------------------+-------+-------------+---------------+-----+-----------------+----------------+
The databases Table¶
At first, the databases table contains two records:
-
filesis one of the default databases within themindsdbdatabase. It stores all the files uploaded to the MindsDB Cloud editor. Following this guide, you can find out how to upload files to MindsDB. -
viewsis one of the default databases within themindsdbdatabase. It stores all the views. Here is how you can create a view in MindsDB.
SELECT *
FROM mindsdb.databases;
On execution, we get:
+-------+----------------+-------+-------+-------+
|name |database_type |host |port |user |
+-------+----------------+-------+-------+-------+
|files |files |[NULL] |[NULL] |[NULL] |
|views |views |[NULL] |[NULL] |[NULL] |
+-------+----------------+-------+-------+-------+
Where:
| Column name | Description |
|---|---|
name |
The name of the database. |
database_type |
The type or engine of the database. |
host |
The host of the database connected to MindsDB. |
port |
The port of the database connected to MindsDB. |
user |
The user of the database connected to MindsDB. |
Example¶
To create a database within MindsDB, follow this guide.
SELECT *
FROM mindsdb.databases;
On execution, we get:
+-------------+----------------+---------------+-------+------------+
|name |database_type |host |port |user |
+-------------+----------------+---------------+-------+------------+
|files |files |[NULL] |[NULL] |[NULL] |
|views |views |[NULL] |[NULL] |[NULL] |
|example_db |postgres |3.220.66.106 |5432 |demo_user |
+-------------+----------------+---------------+-------+------------+