This is the input data used in the following steps:
Copy
Ask AI
SELECT *FROM mysql_demo_db.home_rentalsLIMIT 3;
The sample contains contains information about properties for rent.
Connecting Unstructured Data
Extract data from webpages using the web crawler or upload files to MindsDB.In this example, we fetch data from MindsDB Documentation webpage using the web crawler.
MindsDB enables unifying data from structured and unstructured data sources into a single, queryable interface. This unified view allows seamless querying and model-building across all data without consolidation into one system. Learn more here.Create a knowledge base to store all your data in a single location. Learn more about knowledge bases here.
MindsDB enables generating insightful and accurate responses from unified data using natural language. Learn more here.Create an agent that can answer questions over your unified data from Step 2.
Copy
Ask AI
CREATE AGENT my_agentUSING model = { "provider": "openai", "model_name" : "gpt-4o", "api_key": "your-openai-api-key" }, data = { "knowledge_bases": ["mindsdb.my_kb"], "tables": ["mysql_demo_db.home_rentals"] }, prompt_template = 'mindsdb.my_kb stores data about mindsdb and home rentals, mysql_demo_db.home_rentals stores data about home rentals';
Now you can ask questions over your data.
Copy
Ask AI
SELECT *FROM my_agentWHERE question = 'what is MindsDB?';