Sample MCP Server

@jasoet

Repository

Basic information

About Sample MCP Server

Sample Code to Build MCP Server using golang

Sample MCP Server config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

Sample MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Sample MCP Server?

Sample MCP Server is a Model Context Protocol (MCP) server that connects to a PostgreSQL database. Built with Go and GORM, it provides CRUD operations and aggregation for financial accounts, categories, and transactions. It is intended as a reference implementation for MCP server development.

How to use Sample MCP Server?

Prerequisites: Go 1.24+, Mage, Docker, and Docker Compose. Clone the repository, then start the PostgreSQL database with mage docker:up and build with mage build. For development, run mage dev. Configuration is done via a config.yml file or the MCP_SERVER_CONFIG environment variable.

Key features of Sample MCP Server

Account management (create, read, update, delete)
Category management (create, read, update, delete)
Transaction tracking (create, read, update, delete)
Transaction aggregation (sum, count by account)
Configurable PostgreSQL connection (also supports MySQL and MSSQL)

Use cases of Sample MCP Server

Manage financial accounts with create, read, update, delete operations.
Organize transactions into categories for better tracking.
Record and retrieve financial transactions with amounts, dates, and descriptions.
Aggregate transaction data to compute sums and counts per account.

Frequently asked questions

What runtime dependencies are required?

Go 1.24 or higher, the Mage build tool, Docker and Docker Compose, and a PostgreSQL instance (or the included Docker setup).

How do I configure the database connection?

Copy `config.yml.sample` to `config.yml` and edit the values. You can also point to a custom config file using the `MCP_SERVER_CONFIG` environment variable. Default settings are provided for host, port, user, password, and database name.

Which database systems are supported?

PostgreSQL is the default, but the configuration also supports MySQL and MSSQL via the `Type` field.

How can I run tests?

Unit tests: `mage test`. Integration tests: `mage integrationtest`, which automatically starts Docker services and waits for PostgreSQL.

What does the data model look like?

The model includes three entities: Account (ID, name, type), Category (ID, name, type), and Transaction (amount, date, description, with relationships to accounts and categories).

Comments

More Developer Tools MCP servers

LocalCan

Gives AI agents public URLs (tunnels) for localhost, live HTTP traffic inspection, snapshot publishing, and access control. Part of LocalCan, the ngrok alternative for Mac, Windows and Linux. Free plan.

FARPY

mangomunchr

Verified distributed compute for humans, applications, and agents. Submit Blender, Octane, and video workloads, route them across qualified GPUs, track asynchronous execution, download finished artifacts, and verify FARP

DocBin

Give an agent a place to put large output. Instead of returning 40k characters of a build log into the conversation, it posts the file to DocBin and hands back one short URL. Docs render with syntax highlighting and mark

Raccha AI

Shree Mandadi

MCP-first toolbox for agents: namespaced key-value storage, a FIFO queue, auth, and a handful of stateless utility tools (JWT decode, hashing, cert inspection, CIDR math). Free while in early access. This repository is a

LastPing

Know when your AI agents, cron jobs and CI pipelines fail, stall or go quiet. Your agent sets up monitors from a plain description, tells you what is broken and why, reads run history and traces, and writes notes on inci