The Python MindsDB SDK allows you to connect to a MindsDB server from Python using the HTTP API.
pip install mindsdb_sdk
You can establish a connection to the MindsDB server using the SDK. Here are some examples:
import mindsdb_sdk con = mindsdb_sdk.connect() con = mindsdb_sdk.connect('http://127.0.0.1:47334')
import mindsdb_sdk con = mindsdb_sdk.connect(login='a@b.com', password='-') con = mindsdb_sdk.connect('https://cloud.mindsdb.com', login='a@b.com', password='-')
import mindsdb_sdk con = mindsdb_sdk.connect('http://<YOUR_INSTANCE_IP>', login='a@b.com', password='-', is_managed=True)
Once connected to the server, you can perform various operations. Here are some examples:
# Get a list of databases databases = con.databases.list() # Get a specific database database = databases[0] # Database type object # Perform an SQL query query = database.query('select * from table1') print(query.fetch()) # Create a table table = database.tables.create('table2', query) # Get a project project = con.projects.proj # or use mindsdb project project = con # Perform an SQL query within a project query = project.query('select * from database.table join model1') # Create a view view = project.views.create('view1', query=query) # Get a list of views views = project.views.list() view = views[0] df = view.fetch() # Get a list of models models = project.models.list() model = models[0] # Use a model for prediction result_df = model.predict(df) result_df = model.predict(query) # Create a model timeseries_options = { 'order': 'date', 'window': 5, 'horizon': 1 } model = project.models.create( 'rentals_model', predict='price', query=query, timeseries_options=timeseries_options ) # Describe a model model.describe()
You can find more examples in this Google colab notebook
https://github.com/mindsdb/mindsdb_python_sdk/tree/staging/examples
The API documentation for the MindsDB SDK can be found at https://mindsdb.github.io/mindsdb_python_sdk/.
cd docs
pip install -r requirements.txt
make html
The online documentation is automatically updated by pushing changes to the docs branch.
To run all the tests for the components, use the following command:
env PYTHONPATH=./ pytest
We welcome contributions to the MindsDB SDK. If you'd like to contribute, please refer to the contribution guidelines for more information.
The MindsDB SDK is licensed under the MIT License. Feel free to use and modify it according to your needs