The Postgres API enables users to connect to MindsDB using the PostgreSQL protocol.
If you installed MindsDB locally, use the below command to run its Postgres API:
To connect MindsDB in PostgreSQL, use the psql
client program:
We use the local MindsDB installation with the following parameters:
localhost
55432
mindsdb
mindsdb
Here are the commands that allow you to connect to either a local MindsDB installation or a MindsDB Cloud instance.
Please see this page for implementation details.
Now that you are all set, we recommend you check out our Use Cases section, where you’ll find various examples of regression, classification, time series, and NLP predictions with MindsDB.
To learn more about MindsDB itself, follow the guide on MindsDB database structure. Also, don’t miss out on the remaining pages from the MindsDB SQL section, as they explain a common SQL syntax with examples.
Have fun!