Data Agent Connector

关于

The Data Agent Connector provides a rapid blueprint to transform any SQLAlchemy-compatible database into a fully operational SQL Data Agent. It builds sophisticated search and convenience tools, leveraging LanceDB to index schema and column content, enabling both LLMs via the MCP protocol and UIs through mirrored REST endpoints to safely explore your data. This system abstracts complex database interactions, offering a structured and configurable gateway for intelligent agents and applications to query and understand your data landscape securely and efficiently.

主要功能

• Column-content retrieval via BM25 search over distinct textual values indexed in LanceDB.
• 1 GitHub stars
• Automatic metadata generation, including LLM-summarized tables and LanceDB storage.
• Read-only SQL gateway with configurable safe commands for SQLAlchemy engines.
• Config-driven setup using `databases.toml`, `pyproject.toml`, and `.env` for ease of deployment.
• Dual exposure with FastMCP for agents and mirrored REST endpoints for UI integration.

使用案例

• Enabling LLM agents to safely and intelligently explore and query SQL databases.
• Providing a standardized REST API for UIs to interact with diverse database systems.
• Rapidly deploying data exploration and querying capabilities for any SQLAlchemy-compatible database.