Skip to content

matthewtian3/mindsdb

 
 

Repository files navigation

MindsDB


MindsDB ML-SQL Server enables machine learning workflows for the most powerful databases and data warehouses using SQL. Tweet

  • Developers can quickly add AI capabilities to your applications.
  • Data Scientists can streamline MLOps by deploying ML models as AI Tables.
  • Data Analysts can easily make forecasts on complex data (like multivariate time-series with high cardinality) and visualize them in BI tools like Tableau.

NEW! Check-out the new Hacktoberfest challenges (and the cash:dollar: , laptop:computer: and many other prizes)!

If you like our project then we would truly appreciate a Star ⭐!

Also, check-out the rewards and community programs.


Installation - Overview - Features - Database Integrations - Quickstart - Documentation - Support - Contributing - Mailing lists - License


Machine Learning using SQL

MindsDB

image

Demo

You can try the Mindsdb ML SQL server here (demo).

Installation

To install the latest version of MindsDB please pull the following Docker image:

docker pull mindsdb/mindsdb

Or, use PyPI:

pip install mindsdb

Overview

MindsDB automates and abstracts machine learning models through virtual AI Tables:

Apart from abstracting ML models as AI Tables inside databases, MindsDB has a set of unique capabilities:

  • Easily make predictions over very complex multivariate time-series data with high cardinality

  • An open JSON-AI syntax to tune ML models and optimize ML pipelines in a declarative way

How it works:

  1. Let MindsDB connect to your database.

  2. Train a Predictor using a single SQL statement (make MindsDB learn from historical data automatically) or import your ML model to a Predictor via JSON-AI.

  3. Make predictions with SQL statements (Predictor is exposed as virtual AI Tables). There’s no need to deploy models since they are already part of the data layer.

Check our docs and blog for tutorials and use case examples.

Features

  • Automatic data pre-processing, feature engineering, and encoding
  • Classification, regression, time-series tasks
  • Bring models to production without “traditional deployment” as AI Tables
  • Get models’ accuracy scoring and confidence intervals for each prediction
  • Join ML models with existing data
  • Anomaly detection
  • Model explainability analysis
  • GPU support for models’ training
  • Open JSON-AI syntax to build models and bring your ML blocks in a declarative way

Database Integrations

MindsDB works with most of the SQL and NoSQL databases and data Streams for real-time ML.

Connect your Data Connect your Data Connect your Data
Connect Apache Kafka Connect Microsoft Access Oracle Badge
Connect Amazon Redshift Airtable Badge Pinot Badge
Connect Cassandra DataStax Badge Amazon S3 Badge
Connect Clickhouse Google Big Query Badge SQLite Badge
Connect CockroachDB ckan Badge Supabase Badge
Connect MariaDB Couchbase Badge TiDB Badge
Connect SQL Server CrateDB Badge Timescale Badge
Connect MongoDB DoIt Badge Amazon DynamoDB Badge
Connect MySQL Databricks Badge YugabyteDB Badge
Connect PostgreSQL IBMDB2 Badge
Connect QuestDB Apache Druid Badge
Connect Redis Vertica Badge
Connect SAP HANA Elastic Badge
Connect ScyllaDB Firebird Badge
Connect Singlestore Apache Hive Badge
Connect Snowflake Informix Badge
Connect Teradata Matrixone Badge
Connect Trino Monetdb Badge

❓ 👋 Missing integration?

Quickstart

To get your hands on MindsDB, we recommend using the Docker image or simply sign up for a free cloud account. Feel free to browse documentation for other installation methods and tutorials.

Documentation

You can find the complete documentation of MindsDB at docs.mindsdb.com.

Support

If you found a bug, please submit an issue on Github.

To get community support, you can:

If you need commercial support, please contact MindsDB team.

Contributing

A great place to start contributing to MindsDB will be our GitHub projects for checkered_flag:

Also, we are always open to suggestions so feel free to open new issues with your ideas and we can guide you!

Being part of the core team is accessible to anyone who is motivated and wants to be part of that journey! If you'd like to contribute to the project, refer to the contributing documentation.

Please note that this project is released with a Contributor Code of Conduct. By participating in this project, you agree to abide by its terms.

Current contributors

Made with contributors-img.

Mailing lists

Subscribe to MindsDB Monthly Community Newsletter to get general announcements, release notes, information about MindsDB events, and the latest blog posts. You may also join our beta-users group, and get access to new beta features.

License

MindsDB is licensed under GNU General Public License v3.0

About

In-Database Machine Learning

Resources

License

Code of conduct

Stars

Watchers

Forks

Packages

No packages published

Languages

  • Python 99.6%
  • Other 0.4%