To successfully install MindsDB, use Python 64-bit version. Also, make sure that Python >= 3.9 and pip >= 20.3.

Installation using the Python venv Module

  1. Create a new virtual environment called mindsdb:

    py -m venv mindsdb
    

    Now, activate it:

    .\mindsdb\Scripts\activate.bat
    
  2. Once inside the virtual environment, run the command below to mitigate the dependency issues:

    pip install --upgrade pip setuptools wheel
    
  3. Install MindsDB:

    pip install mindsdb
    
  4. Start MindsDB:

    python -m mindsdb
    

    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
    

Installation using Anaconda

Here, you need either Anaconda or Conda installed on your machine.

  1. Open Anaconda prompt and create a new virtual environment:

    conda create -n mindsdb
    

    Now, activate it:

    conda activate mindsdb
    
  2. Once inside the virtual environment, run the command below to mitigate the dependency issues:

    pip install --upgrade pip setuptools wheel
    
  3. Install MindsDB:

    pip install mindsdb
    
  4. Start MindsDB:

    python -m mindsdb
    

    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
    

Dependencies

The dependencies for many of the data or ML integrations are not installed by default.

If you want to use a data or ML integration whose dependencies are not available by default, install it by running this command:

pip install mindsdb[handler_name]

You can find all available handlers here.

Troubleshooting

Pip and Python Versions

Currently, MindsDB supports Python versions 3.9.x, 3.10.x, and 3.11.x.

To successfully install MindsDB, use Python 64-bit version. Also, make sure that Python >= 3.9 and pip >= 20.3. You can check the pip and python versions by running the pip --version and python --version commands.

Please note that depending on your environment and installed pip and python packages, you might have to use pip3 instead of pip or python3.x instead of py. For example, pip3 install mindsdb instead of pip install mindsdb.

How to Avoid Dependency Issues

Install MindsDB in a virtual environment using pip to avoid dependency issues.

Or you could try to install MindsDB with Anaconda and run the installation from the Anaconda prompt.

In addition, for Windows systems with default languages other than English, your system might not have UTF-8 as the default encoding standard, which will cause encoding errors when installing dependencies. To solve this issue, go to Control Panel > Clock and Region > Region > Administrative tab > Change system locale button and enable Beta: Use Unicode UTF-8 for worldwide language support.

Installing torch or torchvision

If the installation fails when installing torch or torchvision, try to install them manually by following the instructions on their official website.

Further Issues?

You can try to replicate your issue using the Docker setup.

Also, please create an issue with detailed description in the MindsDB GitHub repository so we can help you. Usually, we review issues and respond within a few hours.

What’s Next

Now that you installed and started MindsDB locally in your Docker container, go ahead and find out how to create and train a model using the CREATE MODEL statement. In the MindsDB SQL section, you’ll find a comprehensive overview of the SQL syntax offered by MindsDB. We also provide Mongo-QL syntax documented in the MindsDB Mongo-QL section.

You can connect MindsDB to different clients, including PostgreSQL CLI and MySQL CLI.

Check out the Use Cases section to follow tutorials that cover Large Language Models, Natural Language Processing, Time Series, Classification, and Regression models.