MindsDB's AI SQL Server enables developers to build AI tools that need access to real-time data to perform their tasks.

Enrich datastores by passing new data thorugh 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;

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

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?

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

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

To get community support, you can:

• Post a question at MindsDB Slack community.
• Ask for help at our GitHub Discussions.
• Ask a question at Stackoverflow with a MindsDB tag.

If you need commercial support, please contact MindsDB team.

A great place to start contributing to MindsDB is to check our GitHub projects 🏁

• Community contributor's dashboard tasks.
• First timers only issues, if this is your first time contributing to an open source project.

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.

Made with contributors-img.

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.

For detailed licensing information, please refer to the LICENSE file