AI DataBridge - Multi-Database Connector

One unified interface to query ALL your data sources with natural language.

Stop juggling 7 different database tools. AI DataBridge connects PostgreSQL, MySQL, MongoDB, Airtable, Notion, and Google Sheets through a single MCP interface. Ask questions in plain English—get answers from any database instantly.

---

The Problem

Your data lives everywhere:

• Customer records in PostgreSQL
• Analytics in Google Sheets
• CRM data in Airtable
• Project tracking in Notion
• User sessions in MongoDB

Before AI DataBridge: Switch between 5+ tools, write different query languages, manually combine results.

After AI DataBridge: "Show me customers from Postgres who haven't been contacted in Airtable" → Done.

---

Key Features

Multi-Database Connectivity

Database	Status	Query Type
PostgreSQL	✅ Full Support	SQL
MySQL	✅ Full Support	SQL
SQLite	✅ Full Support	SQL
MongoDB	✅ Full Support	JSON Filter
Airtable	✅ Full Support	API-based
Notion	✅ Full Support	API-based
Google Sheets	✅ Full Support	Range-based

Natural Language Queries

Ask questions in plain English. The AI translates to the right query syntax automatically.

Examples:

• "Get all orders over $100 from last week"
• "Show me active customers who signed up in January"
• "Find products with less than 10 items in stock"
• "List all tasks marked as urgent in Notion"

Schema Discovery

Automatically detect tables, columns, and data types. No manual configuration needed.

Unified Output Format

Every query returns the same JSON structure, regardless of source. Perfect for AI agents and downstream processing.

---

Quick Start

1. Query PostgreSQL

{
    "operation": "query",
    "dataSource": "postgresql",
    "connectionString": "postgresql://user:pass@host:5432/mydb",
    "sqlQuery": "SELECT * FROM customers WHERE status = 'active'"
}

2. Natural Language Query

{
    "operation": "natural_language_query",
    "dataSource": "postgresql",
    "connectionString": "postgresql://user:pass@host:5432/mydb",
    "naturalLanguageQuery": "Show me all orders over $100 from last month",
    "aiApiKey": "your-openrouter-key"
}

3. Query Airtable

{
    "operation": "query",
    "dataSource": "airtable",
    "airtableApiKey": "pat...",
    "airtableBaseId": "appXXXXXXXXXXXXXX",
    "airtableTableName": "Customers"
}

4. Query Notion Database

{
    "operation": "query",
    "dataSource": "notion",
    "notionToken": "ntn_...",
    "notionDatabaseId": "your-database-id"
}

5. Query Google Sheets

{
    "operation": "query",
    "dataSource": "google_sheets",
    "googleSheetsCredentials": "{...service account JSON...}",
    "googleSpreadsheetId": "1ABC...",
    "googleSheetName": "Sheet1"
}

---

Who Uses AI DataBridge?

AI Agent Developers

Connect Claude, GPT, or custom agents to any database through MCP. No database-specific code needed.

Data Analysts

Query multiple sources with one tool. Export unified JSON for BI dashboards.

Startup Teams

Your data is scattered across free tools (Sheets, Notion, Airtable). Now query it all professionally.

Automation Engineers

Build n8n/Make/Zapier workflows that pull from any database with consistent output.

---

Operations

query

Execute a direct query on the specified data source.

natural_language_query

Ask your question in plain English. AI generates and executes the appropriate query.

describe_schema

Get table names, column definitions, and row counts for any data source.

test_connection

Verify that your credentials and connection string are valid.

list_sources

List all supported data source types.

---

Output Format

All queries return data in a unified format:

{
    "_source": "postgresql",
    "_table": "customers",
    "_id": "123",
    "_queriedAt": "2026-01-12T10:30:00Z",
    "name": "John Doe",
    "email": "john@example.com",
    "status": "active"
}

Summary (Key-Value Store):

{
    "success": true,
    "source": "postgresql",
    "table": "customers",
    "rowCount": 150,
    "executionTimeMs": 45
}

---

MCP Integration

With Apify MCP Server

Add to your mcp.json:

{
    "mcpServers": {
        "apify": {
            "url": "https://mcp.apify.com"
        }
    }
}

Then use this Actor through Apify's MCP tools.

Direct API Usage

import { ApifyClient } from 'apify-client';

const client = new ApifyClient({ token: 'YOUR_APIFY_TOKEN' });

const run = await client.actor('the.beast/ai-data-bridge').call({
    operation: 'query',
    dataSource: 'postgresql',
    connectionString: 'postgresql://...',
    sqlQuery: 'SELECT * FROM users LIMIT 10'
});

const { items } = await client.dataset(run.defaultDatasetId).listItems();
console.log(items);

---

Pricing

Pay Per Event - Only pay for what you query.

Event	Price	Description
Actor Start	$0.0001	Per run initialization
Query Result	$0.0001	Per row/record returned
Schema Describe	$0.001	Per schema inspection
AI Query Generation	$0.002	Per natural language translation

Example Costs

Use Case	Estimated Cost
Query 100 rows from PostgreSQL	~$0.01
Daily Airtable sync (500 records)	~$0.05
Natural language query + 50 results	~$0.01
Schema discovery for 10 tables	~$0.01

---

Security

• Connection strings are encrypted and marked as secrets
• Read-only by default - Only SELECT queries for SQL databases
• No data storage - Data flows through, never persisted on Apify
• SSL/TLS - All database connections use encryption when available

---

Comparison with Alternatives

Feature	AI DataBridge	Database MCP Server	Individual Connectors
PostgreSQL	✅	✅	✅
MySQL	✅	✅	✅
MongoDB	✅	❌	Separate tool
Airtable	✅	❌	Separate tool
Notion	✅	❌	Separate tool
Google Sheets	✅	❌	Separate tool
Natural Language	✅	❌	❌
Unified Output	✅	❌	❌
Single Config	✅	✅	❌ (5+ tools)

---

Roadmap

v1.1 (Coming Soon)

• Cross-database JOINs ("Join Airtable customers with PostgreSQL orders")
• Supabase support
• Firebase/Firestore support

v1.2

• Query caching for repeated requests
• Scheduled queries with webhooks
• Write operations (INSERT/UPDATE)

---

Support

• Issues: GitHub Issues
• Docs: Apify Actor Page
• Contact: Open an issue for feature requests

---

Changelog

v1.0.0 (2026-01-12)

• Initial release
• PostgreSQL, MySQL, SQLite support with full SQL
• MongoDB support with JSON filter queries
• Airtable support with API-based queries
• Notion support with database queries
• Google Sheets support with range-based queries
• Natural language query processing via OpenRouter
• Schema discovery for all sources
• Unified JSON output format

---

License

MIT License - Use freely in personal and commercial projects.

---

Keywords: AI database connector, multi-database integration, natural language SQL, Airtable API, Notion API, Google Sheets API, PostgreSQL connector, MySQL connector, MongoDB connector, MCP server, Claude database, GPT database, AI data integration, unified data access, cross-platform data bridge, database query tool, AI-powered data retrieval, semantic data search, federated data querying