fastmcp-sqltools
A MCP server provides SQL database access with support for PostgreSQL, MySQL, and SQLite.
MCP 服务配置
复制以下 JSON 到 OPClaw 或其他 MCP 客户端的配置文件中即可使用
{
"mcpServers": {
"fastmcp-sqltools": {
"args": [
"fastmcp-sqltools@0.3.0"
],
"command": "uvx"
}
}
}可用工具 （5 个）
该服务在 MCP 协议中暴露的工具，AI 可按需调用
tavily_search 14 个参数 需填 1 项
Search the web for current information on any topic. Use for news, facts, or data beyond your knowledge cutoff. Returns snippets and source URLs.
必填参数：query
tavily_extract 6 个参数 需填 1 项
Extract content from URLs. Returns raw page content in markdown or text format.
必填参数：urls
tavily_crawl 11 个参数 需填 1 项
Crawl a website starting from a URL. Extracts content from pages with configurable depth and breadth.
必填参数：url
tavily_map 8 个参数 需填 1 项
Map a website's structure. Returns a list of URLs found starting from the base URL.
必填参数：url
tavily_research 2 个参数 需填 1 项
Perform comprehensive research on a given topic or question. Use this tool when you need to gather information from multiple sources to answer a question or complete a task. Returns a detailed response based on the research findings.
必填参数：input
服务介绍
FastMCP SQL Tools
mcp-name: io.github.atarkowska/fastmcp-sqltools
A Model Context Protocol (MCP) server built with FastMCP that provides SQL database access with support for PostgreSQL, MySQL, and SQLite.
# Features
- list_tables: List all tables in the database
- get_table_schema: Get detailed schema information for a table including columns, types, constraints, and indexes
- execute_query: Execute any SQL query (INSERT, UPDATE, DELETE, DDL, etc.)
- execute_safe_query: Execute read-only SELECT queries with additional safety checks
# Supported Databases
- PostgreSQL: Full support via asyncpg
- MySQL: Full support via aiomysql
- SQLite: Full support via aiosqlite
The server automatically detects the database type from the DATABASE_URL environment variable.
# Configuration
[](https://github.com/atarkowska/fastmcp-sqltools/blob/main/README.md# configuration)
Add the following to your claude_desktop_config.json:
{
"mcpServers": {
"sql-mcp-tools": {
"command": "uvx",
"args": [
"fastmcp-sqltools"
],
"env": {
"DATABASE_URL": "<your-database-url>"
}
}
}
}
# # Database URL Format
The DATABASE_URL should be in one of the following formats:
- PostgreSQL:
postgresql://user:password@host:port/databaseorpostgres://user:password@host:port/database - MySQL:
mysql://user:password@host:port/database - SQLite:
sqlite:///path/to/database.db(use three slashes for absolute path)
# License
This project is licensed under the GNU Affero General Public License v3.0 (AGPL-3.0).
See the LICENSE file for details.
