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

directree

coburn2716

directree MCP server — query the honest software directory from any AI assistant

Mcp-Warden

ermoluk

Local-first credential broker for MCP. AI coding agents (Claude Code, Cursor, Codex…) call APIs, SSH and databases through scoped presets; secrets stay in your OS keychain and never enter the agent's context.

Eddyter AI Rich Text Editor MCP

EddyterAI

Set up and manage the Eddyter AI rich text editor by talking to your AI agent — for Claude, Cursor, Codex and other MCP tools. A Model Context Protocol server that lets AI tools add Eddyter to a React, Next.js, Vite or R

JiCo for Jira & Confluence – PII-redacting MCP server with Human-in-the-Loop

drkv-com

JiCo for Jira & Confluence: local MCP server for Jira Data Center - redacts personal data before the AI model, holds every write for approval

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