About DBtoolReader
DBtoolReader is a Go server for querying PostgreSQL databases and retrieving schema information. It is designed for LLM systems and communicates over standard input and output.
Key features
- 01Run PostgreSQL queries
- 02Retrieve database schema
- 03Communicate over stdio
- 04Built with the MCP-Go framework
Use cases
- 01Run queries against a PostgreSQL database
- 02Inspect database schema from an LLM system
MCP support
It implements an MCP server using the MCP-Go framework and exposes query execution and schema retrieval tools to MCP clients over stdio.
Configuration
Local server config is the same for every client. Copy it into your client’s MCP config file.
We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.
Tools
Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.
Details
From the project READMEDBtoolReader
DBtoolReader is a PostgreSQL database tool that provides a server interface for executing database queries and retrieving schema information. It's built using Go and integrates with the MCP (Model-Controller-Protocol) server framework which make it usable with any LLM and LLM System.
Features
- Execute PostgreSQL database queries
- Retrieve database schema information
- Stdio-based server interface
- Built on the MCP-Go framework
Prerequisites
- Go 1.16 or higher
- PostgreSQL database
- Access credentials for your PostgreSQL database
Installation
- Clone the repository:
git clone [repository-url]
cd DBtoolReader
- Install dependencies:
go mod download
- Build the project:
go build -o dbtoolreader
Usage
The tool provides two main functionalities:
- Database Query Tool: Execute queries against your PostgreSQL database
- Schema Tool: Retrieve schema information from your PostgreSQL database
The server communicates through standard input/output, making it suitable for integration with other tools and services.
Running the Server
./dbtoolreader
The server will start and listen for commands through stdin/stdout.
Project Structure
main.go- Entry point of the applicationtools/- Directory containing the core functionalitydbQueryTool.go- Implementation of the database query functionalitygetSchemaTool.go- Implementation of the schema retrieval functionality
Dependencies
github.com/mark3labs/mcp-go- MCP server framework- Other dependencies as listed in
go.mod
Contributing
Contributions are welcome! Please feel free to submit a Pull Request.
License
[Add your license information here]
Support
For support, please [add contact information or issue tracker details]
Comments
New to MCP?
From what the protocol is to installing your first server, these answers cover most first questions.
An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.