Unified AI and data gateway
## MindsDB MCP Server: AI Tables for Databases The **MindsDB MCP Server** integrates MindsDB's AI-powered database layer into Google Antigravity. This platform allows you to create AI models as database tables, querying them with SQL alongside your regular data. ### Why MindsDB MCP? MindsDB brings AI to SQL: - **AI as Tables**: Query models like database tables - **AutoML**: Automatic model selection and training - **Data Integration**: Connect to 100+ data sources - **Real-Time**: Make predictions on live data - **SQL Interface**: Use familiar SQL syntax ### Key Features #### 1. Create AI Models ```sql -- Create a prediction model CREATE MODEL sales_forecast FROM postgres_db (SELECT * FROM sales_data) PREDICT next_month_sales; -- Query predictions like a table SELECT * FROM sales_forecast WHERE region = 'West' AND product_category = 'Electronics'; ``` #### 2. Connect Data Sources ```sql -- Connect to any database CREATE DATABASE my_postgres WITH ENGINE = 'postgres', PARAMETERS = { "host": "localhost", "port": 5432, "database": "mydb", "user": "user", "password": "pass" }; -- Use with AI models CREATE MODEL churn_predictor FROM my_postgres (SELECT * FROM customers) PREDICT will_churn; ``` #### 3. LLM Integration ```sql -- Create LLM-powered model CREATE MODEL sentiment_analyzer PREDICT sentiment USING engine = 'openai', model_name = 'gpt-4', prompt_template = 'Analyze sentiment: {{text}}'; -- Use in queries SELECT text, sentiment FROM reviews r JOIN sentiment_analyzer WHERE r.date > '2024-01-01'; ``` ### Configuration ```json { "mcpServers": { "mindsdb": { "command": "npx", "args": ["-y", "@anthropic/mcp-mindsdb"], "env": { "MINDSDB_HOST": "localhost", "MINDSDB_PORT": "47334", "MINDSDB_USER": "mindsdb", "MINDSDB_PASSWORD": "your-password" } } } } ``` ### Use Cases **Predictive Analytics**: Add predictions to SQL queries without ML expertise. **Data Enrichment**: Enhance data with AI-generated columns. **Real-Time ML**: Make predictions on streaming data with SQL. The MindsDB MCP Server brings AI directly into database workflows.
{
"mcpServers": {
"mindsdb": {
"mcpServers": {
"mindsdb": {
"args": [
"mindsdb-mcp"
],
"command": "uvx"
}
}
}
}
}