Scansca - MCP Database Connector (under-development)

What is Scansca - MCP Database Connector (under-development)?

Scansca is a self‑hostable server that connects Large Language Model (LLM) clients to database systems via the Model Context Protocol (MCP). It allows technical users to gain integrated insights from diverse data environments using natural language.

How to use Scansca - MCP Database Connector (under-development)?

Install Go 1.22+ and optionally Docker. Clone the repository, run make deps, optionally start a PostgreSQL database with make docker-compose, then make run. Register a database via POST /api/v1/databases and execute queries via POST /api/v1/query. MCP‑compatible clients use GET /mcp/v1/tools and POST /mcp/v1/tools/:name/invoke. Documentation is served by make docs.

Key features of Scansca - MCP Database Connector (under-development)

• Multi‑database support: PostgreSQL (MySQL, SQLite, DynamoDB coming soon)
• Seamless MCP integration with LLM clients
• Automatic schema discovery with minimal configuration
• Simple RESTful API for database operations
• Docker‑ready deployment with Docker Compose
• Self‑hostable, full control over infrastructure

Use cases of Scansca - MCP Database Connector (under-development)

• Query databases using natural language via MCP‑compatible LLM clients
• Connect LLM applications to existing PostgreSQL databases
• Enable non‑technical users to explore data through conversational interfaces
• Integrate dynamic database access into AI workflows

FAQ from Scansca - MCP Database Connector (under-development)

Which databases are currently supported?

Only PostgreSQL is supported at this time. Support for MySQL, SQLite, and DynamoDB is planned.

What are the runtime dependencies?

Go 1.22+ is required. Docker and Docker Compose are optional (used for spinning up a test PostgreSQL instance).

Does Scansca handle authentication?

The README does not describe authentication or authorization; API endpoints are unprotected in the shown quick start.

Where does the data live?

Data remains on the configured database servers. Scansca connects to them and does not store data itself.

What is the license?

Free for non‑commercial use, non‑profits, and small entities (under $10,000 USD revenue/assets). Commercial and government use requires a separate license from the author.