MyPos MCP DB

You run a MyPos MCP DB server that connects to MySQL or PostgreSQL databases and provides practical tools to inspect, modify, and manage your data model and records through a Model-Context-Protocol (MCP) interface.

How to use

To leverage MCP, connect with an MCP client and select this server as your data backend. You can list tables, inspect columns, run SELECT queries, and perform CRUD operations across your tables. The available tools are designed to help you build and manage your database schema and data without leaving your MCP client.

How to install

Prerequisites you need before running the server are a recent Node.js runtime and a running database instance (MySQL or PostgreSQL). Ensure Node.js is v16 or newer and that your chosen database is accessible from the hosting environment.

# 1) Clone the project
git clone https://github.com/Yonsn76/MyPos-MCP.git
cd MyPos-MCP

# 2) Install dependencies
npm install

# 3) Create environment configuration
# In the project root, create a .env file with these values:
DB_TYPE=mysql       # or postgres
DB_HOST=localhost
DB_PORT=3306        # or 5432 for postgres
DB_USER=root
DB_PASSWORD=your_password
DB_DATABASE=your_database
```} ,{

Additional content

Configuration reflects how you connect to your database. The server runs with a single command to start after dependencies are installed and environment variables are set. You can start the server with the usual package script used by Node.js projects.

# Start the MCP server after configuring .env
npm start
```} ,{

Tools for database interaction

The server exposes a set of tools to manage your database schema and data. Each tool is designed to be invoked via the MCP interface to perform specific tasks.

Tool list

• ListarTablas: Enumerates all tables in the database.

• ConsultarSQL: Executes a SELECT query and returns results.

• ColumnasDeTabla: Lists the columns of a specific table.

• CrearTabla: Creates a new table from a definition object.

• EliminarTabla: Deletes a table from the database.

• RenombrarTabla: Renames an existing table.

• AgregarColumna: Adds a new column to an existing table.

• EliminarColumna: Removes a column from a table.

• RenombrarColumna: Renames a column within a table.

• CambiarTipoColumna: Changes a column’s data type (e.g., DATE, VARCHAR).

• InsertarDatos: Inserts one or more records into a table.

• CrudTabla: Performs create, read, update, delete operations on any table.

• AgregarClaveForanea: Adds a FOREIGN KEY between tables.

• EliminarClaveForanea: Removes a FOREIGN KEY by name.

• ExportarTabla: Exports table data or specific columns to CSV or JSON.

• ImportarTabla: Imports data from CSV or JSON into a table, allowing column mapping.

Example MCP configuration snippet

"MyPost MCP": { 
  "type": "stdio", 
  "command": "npx", 
  "args": [ 
    "-y", 
    "node", 
    "C:/Users/Pociko/Desktop/MCP/legion-mcp/Mi-mcp/mcp_server.js"
    // Aqui va la url del directorio en la cual esta el archivo mcp_server.js
  ] 
}

Available tools

listarTablas

Lists all tables in the connected database.

consultarSQL

Runs a SELECT query and returns the corresponding results.

columnasDeTabla

Shows the columns defined on a specified table.

crearTabla

Creates a new table from a given definition object.

eliminarTabla

Deletes a table from the database.

renombrarTabla

Renames an existing table to a new name.

agregarColumna

Adds a new column to an existing table.

eliminarColumna

Removes a column from a table.

renombrarColumna

Renames a column within a table.

cambiarTipoColumna

Alters a column’s data type (e.g., to DATE, VARCHAR).

insertarDatos

Inserts one or more rows into a table.

crudTabla

Performs full CRUD operations on a chosen table.

agregarClaveForanea

Adds a FOREIGN KEY constraint between tables.

eliminarClaveForanea

Removes a FOREIGN KEY constraint by name.

exportarTabla

Exports data from a table or specific columns to CSV or JSON.

importarTabla

Imports data into a table from CSV or JSON, with optional column mapping.