simple-mcp

Simple MCP Server

A Model Context Protocol (MCP) server that provides tools for interacting with simple's data, including customer reports, calendar events, and company information.

Prerequisites

• Node.js (v18 or higher)
• Yarn package manager
• PostgreSQL database (for database-related tools)
• Access to the required environment variables

Installation

1. Clone the repository and navigate to the project directory:

   cd simple-mcp

1. Install dependencies:

   yarn install

1. Set up environment variables:

Create a .env file in the root directory based on .env.example: ``bash cp .env.example .env ``

Configure the following environment variables in your .env file: ``env DB_HOST=localhost DB_PORT=5432 DB_NAME=postgres DB_USER=postgres DB_PASSWORD=your_password ``

Building the Project

Build the TypeScript project: ``bash yarn build ``

This will:

• Compile TypeScript files to JavaScript in the build/ directory
• Make the entry point executable

Running the MCP Server

Development

To run the server directly (for testing): ``bash node build/index.js ``

The server runs on stdio (standard input/output) and communicates via the MCP protocol.

Using with Cursor

To use this MCP server with Cursor, add it to your Cursor settings:

1. Open Cursor Settings
2. Navigate to MCP Servers configuration
3. Add the following configuration:

{
  "mcpServers": {
    "simple-mcp": {
      "command": "node",
      "args": ["/absolute/path/to/simple-mcp/build/index.js"],
      "env": {
        "DB_HOST": "localhost",
        "DB_PORT": "5432",
        "DB_NAME": "postgres",
        "DB_USER": "postgres",
        "DB_PASSWORD": "your_password"
      }
    }
  }
}

Replace /absolute/path/to/simple-mcp with the actual absolute path to this project directory.

Using with Other MCP Clients

The server communicates via stdio using the MCP protocol. Any MCP-compatible client can connect to it by running: ``bash node build/index.js ``

Available Tools

The server provides the following tools:

• getName: Get a name
• getCustomersReport: Get a customers report
• listCalendarEvents: List all calendar events
• fetchCompaniesData: Query PostgreSQL database to fetch all companies data from the companies table

Project Structure

simple-mcp/
├── src/
│   ├── index.ts          # Main entry point
│   ├── server.ts         # MCP server setup
│   ├── tools/            # Tool implementations
│   └── utils/            # Utility functions (database, data generators)
├── build/                # Compiled JavaScript output
├── package.json
├── tsconfig.json
└── README.md

Development

• Source files are in src/
• Compiled output goes to build/
• Run yarn build after making changes to TypeScript files

Troubleshooting

• Database connection errors: Ensure PostgreSQL is running and the connection details in .env are correct
• Build errors: Make sure all dependencies are installed with yarn install
• Permission errors: The build script sets executable permissions, but if issues persist, run chmod +x build/index.js