/mindsdb

The platform for customizing AI from enterprise data

Primary LanguagePythonOtherNOASSERTION

MindsDB

MindsDB Release Python supported PyPi Version
PyPI - Downloads Docker pulls MindsDB Website MindsDB Community


MindsDB is the platform for customizing AI from enterprise data. You can create, serve, and fine-tune models in real-time from your database, vector store, and application data. Tweet

We believe AI will help every company thrive, but off-the-shelf, generic AI usually doesnโ€™t completely meet their needs. With MindsDBโ€™s nearly 200 integrations, any developer can create AI customized for their purpose, faster and more securely. Their AI systems will constantly improve themselves โ€” using companiesโ€™ own data, in real-time.

MindsDB "enhances" SQL syntax with AI capabilities to make it accessible for developers worldwide:

๐ŸŽฏ Solutions โš™๏ธ SQL Query Examples
๐Ÿค– Fine-Tuning FINETUNE mindsdb.hf_model FROM postgresql.table;
๐Ÿ“š Knowledge Base CREATE KNOWLEDGE_BASE my_knowledge FROM (SELECT contents FROM drive.files);
๐Ÿ” Semantic Search SELECT * FROM rag_model WHERE question='What product is best for treating a cold?';
โฑ๏ธ Real-Time Forecasting SELECT * FROM binance.trade_data WHERE symbol = 'BTCUSDT';
๐Ÿ•ต๏ธ Agents CREATE AGENT my_agent USING model='chatbot_agent', skills = ['knowledge_base'];
๐Ÿ’ฌ Chatbots CREATE CHATBOT slack_bot USING database='slack',agent='customer_support';
โฒ๏ธ Time Driven Automation CREATE JOB twitter_bot ( <sql_query1>, <sql_query2> ) START '2023-04-01 00:00:00';
๐Ÿ”” Event Driven Automation CREATE TRIGGER data_updated ON mysql.customers_data (sql_code)

โšก๏ธ Quick Example

Enrich datastores by passing new data through an AI-model and writing results back in the database, this can be solved in a few lines of AI-SQL. Here is a reference architecture:

Let's look at automating shopify orders analysis:

---This query creates a job in MindsDB to analyze Shopify orders.
---It predicts customer engagement scores based on recent completed orders
---and inserts these insights into a customer_engagement table.
---The job runs every minute, providing ongoing updates to the engagement scores.

CREATE JOB mindsdb.shopify_customer_engagement_job AS (

   -- Insert into a table insights about customer engagement based on recent Shopify orders
   INSERT INTO shopify_insights.customer_engagement (customer_id, predicted_engagement_score)
      SELECT
         o.customer_id AS customer_id,
         r.predicted_engagement_score AS predicted_engagement_score
      FROM shopify_data.orders o
      JOIN mindsdb.customer_engagement_model r
         WHERE
            o.order_date > LAST
         AND o.status = 'completed'
      LIMIT 100
)
EVERY minute;

โš™๏ธ Installation

To install locally or on-premise, pull the latest Docker image:

docker pull mindsdb/mindsdb

or, use pip:

pip install mindsdb

Read more about Installation

๐Ÿ”— Data Integrations

MindsDB allows querying hundreds of data sources, such as databases (both relational and non-relational), data warehouses, streams, and SaaS application data, using standard SQL. This capability stems from MindsDBโ€™s unique ability to translate SQL into real-time data requests. You can find the list of all supported integrations here.

โ“ ๐Ÿ‘‹ Missing integration?

๐Ÿ“– 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 is to check our GitHub projects ๐Ÿ

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.

This project is released with a Contributor Code of Conduct. By participating in this project, you agree to follow its terms.

Also, check out the rewards and community programs.

๐Ÿ’š Current contributors

Made with contributors-img.

๐Ÿ”” Subscribe to updates

Join our Slack community and subscribe to the monthly Developer Newsletter to get product updates, information about MindsDB events and contests, and useful content, like tutorials.

โš–๏ธ License

For detailed licensing information, please refer to the LICENSE file