Skip to content

postgres-client.mdx

Latest commit

 

History

History
53 lines (36 loc) · 1.5 KB

postgres-client.mdx

File metadata and controls

53 lines (36 loc) · 1.5 KB
title MindsDB and Postgres CLI
sidebarTitle Postgres CLI

The Postgres API enables users to connect to MindsDB using the PostgreSQL protocol.

By default, MindsDB starts the `http` and `mysql` APIs. You can define which APIs to start using the `api` flag as below. 
python -m mindsdb --api http,mysql,postgres,mongodb

If you want to start MindsDB without the graphical user interface (GUI), use the --no_studio flag as below.

python -m mindsdb --no_studio

How to Connect

To connect MindsDB in PostgreSQL, use the psql client program:

psql -h localhost -p 55432 -d mindsdb -U mindsdb

We use the local MindsDB installation with the following parameters:

  • host: localhost
  • port: 55432
  • database: mindsdb
  • user: mindsdb

Here is the command that allows you to connect to MindsDB.

psql -h 127.0.0.1 -p 47335 -d mindsdb -U mindsdb
Please see [this page](https://github.com/mindsdb/mindsdb/tree/main/mindsdb/api/postgres) for implementation details.

What's Next?

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!