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
   

2. Install dependencies:

   yarn install
   

3. Set up environment variables: Create a .env file in the root directory based on .env.example:

   cp .env.example .env
   

   Configure the following environment variables in your .env file:

   DB_HOST=localhost
   DB_PORT=5432
   DB_NAME=postgres
   DB_USER=postgres
   DB_PASSWORD=your_password
   

Building the Project

Build the TypeScript project:

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):

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:

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