Skip to main content
Glama

ToolFront MCP Server

by kruskal-labs

AI agents lack context about your databases, while teams keep rewriting the same queries because past work often gets lost. ToolFront connects agents to your databases and feeds them your team's proven query patterns, so both agents and teammates can learn from each other and ship faster.

Features

  • ⚡ One-step setup: Connect coding agents like Cursor, GitHub Copilot, and Claude to all your databases with a single command.
  • 🔒 Privacy-first: Your data never leaves your machine, and is only shared between agents and databases through a secure MCP server.
  • 🧠 Collaborative learning: The more your team uses ToolFront, the better your AI agents understand your databases and query patterns.

Quickstart

ToolFront runs on your computer through an MCP server, a secure protocol that lets apps provide context to LLM models.

Step 1: Choose Your Method

You'll need uv or Docker to run the MCP server, and optionally an API key to activate collaborative learning. UV is recommended for most user as it automatically handles dependencies, while Docker is ideal for containerized environments.

Step 2: Setup ToolFront

Option A: One-Click Setup

Click one of these buttons to automatically configure ToolFront in your IDE:

Using UV:

Using Docker:

Option B: Manual Configuration

Add this configuration to your AI assistant's MCP settings:

Using UV:
{ # Rest of config file "toolfront": { "command": "uvx", "args": [ "toolfront", "snowflake://user:pass@org", "bigquery://proj/ds?credentials_path=credentials.json", # Add other database URLs here "--api-key", "YOUR-API-KEY" // Optional ] } }
Using Docker:
{ # Rest of config file "toolfront": { "command": "docker", "args": [ "run", "-i", "antidmg/toolfront", "snowflake://user:pass@org", "bigquery://proj/ds?credentials_path=credentials.json", # Add other database URLs here "--api-key", "YOUR-API-KEY" // Optional ] } }

Tip

Version control: You can pin to specific versions for consistency. Use toolfront==0.1.x for UV or antidmg/toolfront:0.1.x for Docker.

Where to add the configuration:

Option C: Command Usage

Run ToolFront directly in your terminal:

# Using UV uvx toolfront "snowflake://user:pass@org" "bigquery://proj/ds?path/credentials.json" --api-key "YOUR-API-KEY" # Using Docker docker run -i antidmg/toolfront "snowflake://user:pass@org" "bigquery://proj/ds?path/credentials.json" --api-key "YOUR-API-KEY"

Tip

Localhost databases: When using Docker with localhost databases, add --network host before the image name.

Collaborative In-context Learning

Data teams keep rewriting the same queries because past work often gets siloed, scattered, or lost. ToolFront teaches AI agents how your team works with your databases through in-context learning. With ToolFront, your agents can:

  • Reason about historical query patterns
  • Remember relevant tables and schemas
  • Reference your and your teammates' work

Note

In-context learning is currently in open beta. To request an API key, please email Esteban at esteban@kruskal.ai.

Model Context Protocol (MCP)

ToolFront's MCP server comes with seven database tools for AI agents.

Databases

When configuring ToolFront, use the fully-specified connection URL for your databases:

DatabaseURL Example
BigQuerybigquery://project/dataset
DuckDBduckdb:///path/to/db.duckdb
MySQLmysql://user:pass@host:port/db
PostgreSQLpostgresql://user:pass@host:port/db
Snowflakesnowflake://user:pass@account/db
SQLitesqlite:///path/to/db.sqlite

Don't see your database? Submit an issue or pull request, or let us know in our Discord!

Tools

ToolFront provides AI agents with the following database tools:

ToolDescription
testTests whether a data source connection is working
discoverDiscovers and lists all configured databases and file sources
scanSearches for tables using regex, fuzzy matching, or TF-IDF similarity
inspectInspects table schemas, showing column names, data types, and constraints
sampleRetrieves sample rows from tables to understand data content and format
queryExecutes read-only SQL queries against databases with error handling
learnRetrieves relevant queries or tables for in-context learning

FAQ

ToolFront has three key advantages: multi-database support, privacy-first architecture, and collaborative learning.

Multi-database support: While some general-purpose MCP servers happen to support multiple databases, most database MCPs only work with one database at a time, forcing you to manage separate MCP servers for each connection. ToolFront connects to all your databases in one place.

Privacy-first architecture: Other multi-database solutions route your data through the cloud, which racks up egress fees and creates serious privacy, security, and access control issues. ToolFront keeps everything local.

Collaborative learning: Database MCPs just expose raw database operations. ToolFront goes further by teaching your AI agents successful query patterns from your team's work, helping them learn your specific schemas and data relationships to improve over time.

Agent memory stores conversation histories for individuals, whereas ToolFront's collaborative learning remembers relational query patterns across your team and databases.

When one teammate queries a database, that knowledge becomes available to other team members using ToolFront. The system gets smarter over time by learning from your team's collective database interactions.

With an API key, ToolFront only logs the query syntax and their descriptions generated by your AI agents. It never collects your actual database content or personal information. For details, see the query and learn functions in tools.py.

  • Local execution: All database connections and queries run on your machine
  • No secrets exposure: Database credentials are never shared with AI agents
  • Read-only operations: Only safe, read-only database queries are allowed
  • No data transmission: Your database content never leaves your environment
  • Secure MCP protocol: Direct communication between agents and databases with no third-party storage

Run the uvx toolfront or docker run commands with your database URLs directly from the command line. ToolFront automatically tests all connections before starting and shows detailed error messages if any connection fails.

If you're still having trouble, double-check your database URLs using the examples in the Databases section above.

Support & Community

Need help with ToolFront? We're here to assist:

Contributing

See CONTRIBUTING.md for guidelines on how to contribute to ToolFront.

License

ToolFront is released under the GPL License v3. This means you are free to use, modify, and distribute the software, subject to the terms and conditions of the GPL v3 License. For the full license text, see the LICENSE file in the repository.

-
security - not tested
A
license - permissive license
-
quality - not tested

local-only server

The server can only run on the client's local machine because it depends on local resources.

Securely connects AI agents to multiple databases simultaneously while enabling collaborative learning from team query patterns, all while keeping data private by running locally.

  1. Quickstart
    1. Step 1: Choose Your Method
    2. Step 2: Setup ToolFront
  2. Collaborative In-context Learning
    1. Model Context Protocol (MCP)
      1. Databases
      2. Tools
    2. FAQ
      1. Support & Community
        1. Contributing
          1. License

            Related MCP Servers

            • A
              security
              F
              license
              A
              quality
              Enables AI models to perform MySQL database operations through a standardized interface, supporting secure connections, query execution, and comprehensive schema management.
              Last updated -
              7
              35
              22
              JavaScript
            • -
              security
              F
              license
              -
              quality
              Integrates with the AgentCraft framework to enable secure communication and data exchange between AI agents, supporting both premade and custom enterprise AI agents.
              Last updated -
              Python
              • Apple
              • Linux
            • -
              security
              F
              license
              -
              quality
              Enables secure interaction with MySQL databases, allowing AI assistants to list tables, read data, and execute SQL queries through a controlled interface.
              Last updated -
              Python
              • Linux
              • Apple
            • -
              security
              F
              license
              -
              quality
              A powerful server that enables AI agents to interact with MySQL databases, execute SQL queries, and manage database content through a simple interface.
              Last updated -
              25
              4
              JavaScript
              • Apple

            View all related MCP servers

            MCP directory API

            We provide all the information about MCP servers via our MCP API.

            curl -X GET 'https://glama.ai/api/mcp/v1/servers/kruskal-labs/toolfront'

            If you have feedback or need assistance with the MCP directory API, please join our Discord server