DB Query

DB Query

An AI assistant database query tool supporting the MCP protocol

Database Developer tools #Database Query #MCP Protocol #Multi-Database .Go

rating : 2.5 points

downloads : 6.3K

update time : 2025-04-28

What is db-mcp?

db-mcp is a small utility tool for connecting to and querying databases. It supports mainstream database systems such as PostgreSQL, MySQL, and SQLite, and allows connections through a simple DSN (Data Source Name).

How to use db-mcp?

Using db-mcp is very simple. You just need to provide the correct DSN and then perform connection or query operations to obtain the required data.

Applicable Scenarios

db-mcp is suitable for application scenarios that require quick database content queries, such as data analysis, report generation, or integration into other tools.

Main Features

Database Connection

Supports connecting to PostgreSQL, MySQL, and SQLite databases through DSN.

Run Queries

Allows executing SQL queries and returning results in CSV format.

Get Database Information

Can display information about the currently connected database, such as version and type.

Advantages

Supports multiple database systems.

Easy to install and use.

Provides a clear result output format (e.g., CSV).

Limitations

Depends on the driver of the target database.

Some advanced features may require manual DSN configuration.

How to Use

Install db-mcp

Install the db-mcp tool using the go install command.

Connect to the Database

Use the connect command to connect to your database.

Run Queries

Use the query command to execute SQL queries.

Usage Examples

Example 1: Connect to a PostgreSQL Database

Use db-mcp to connect to a PostgreSQL database and run queries.

Example 2: Query the User Table

Query the user table data in the specified database.

Frequently Asked Questions

How to construct a DSN?

Does db-mcp support other databases?

Related Resources

GitHub Project Homepage

The official code repository for db-mcp.

PostgreSQL Official Documentation

Detailed documentation about PostgreSQL.

MySQL Official Documentation

Detailed documentation about MySQL.

A Python-based MCP Server that provides advanced to-do list management and content organization functions through the Notion API, enabling seamless integration between AI models and Notion.

Markdownify MCP

Markdownify is a multi-functional file conversion service that supports converting multiple formats such as PDFs, images, audio, and web page content into Markdown format.

Gitlab MCP Server

The GitLab MCP server is a project based on the Model Context Protocol that provides a comprehensive toolset for interacting with GitLab accounts, including code review, merge request management, CI/CD configuration, and other functions.

Duckduckgo MCP Server

The DuckDuckGo Search MCP Server provides web search and content scraping services for LLMs such as Claude.

UnityMCP is a Unity editor plugin that implements the Model Context Protocol (MCP), providing seamless integration between Unity and AI assistants, including real - time state monitoring, remote command execution, and log functions.

Figma Context MCP

Framelink Figma MCP Server is a server that provides access to Figma design data for AI programming tools (such as Cursor). By simplifying the Figma API response, it helps AI more accurately achieve one - click conversion from design to code.

Gmail MCP Server

A Gmail automatic authentication MCP server designed for Claude Desktop, supporting Gmail management through natural language interaction, including complete functions such as sending emails, label management, and batch operations.

Context7 MCP is a service that provides real-time, version-specific documentation and code examples for AI programming assistants. It is directly integrated into prompts through the Model Context Protocol to solve the problem of LLMs using outdated information.

AIBase

Zhiqi Future, Your AI Solution Think Tank

English 简体中文繁體中文にほんご

© 2025AIBase