Ectlocal Connect MCP Server

EC PostgreSQL , MCP(Model Context Protocol) .

• PostgreSQL
• (/)

1.

npm install

2.

.env.example .env :

cp .env.example .env
# .env  ECTLOCAL_DB_PASSWORD 

3.

npm run build

npm run dev

npm start

MCP

1. execute_query

SQL .

:

• query (string): SQL

:

SELECT COUNT(*) FROM orders WHERE order_date >= '2025-01-01'

2. get_table_structure

, , .

:

• table_name (string):

:

table_name: orders

3. list_tables

ec_ectlocal .

:

4. get_order

ID .

:

• order_id (string): ID

:

order_id: 20250804-0000020

5. get_order_detail

order_manage .

:

• order_id (string): ID

6. get_member

ID .

:

• member_id (string): ID

:

member_id: ectlocal

Claude Desktop

Claude Desktop MCP :

1: .env ()

MCP .env .

macOS - ~/Library/Application Support/Claude/claude_desktop_config.json:

{
  "mcpServers": {
    "ectlocal-connect": {
      "command": "node",
      "args": ["/Users/wjsong/Workspace/MCP/ectlocal-connect/dist/index.js"]
    }
  }
}

Windows - %APPDATA%/Claude/claude_desktop_config.json:

{
  "mcpServers": {
    "ectlocal-connect": {
      "command": "node",
      "args": ["C:\\Users\\wjsong\\Workspace\\MCP\\ectlocal-connect\\dist\\index.js"]
    }
  }
}

2:

Claude Desktop .

macOS:

{
  "mcpServers": {
    "ectlocal-connect": {
      "command": "node",
      "args": ["/Users/wjsong/Workspace/MCP/ectlocal-connect/dist/index.js"]
    }
  }
}

• Host: your_db_host
• Port: your_db_pord
• Database: your_database
• Schema: your_schema
• User: db_user

• orders:
• order_manage:
• member:

• npm run build: TypeScript
• npm run dev:
• npm start:

• @modelcontextprotocol/sdk: MCP SDK
• pg: PostgreSQL
• dotenv:
• typescript: TypeScript
• tsx: TypeScript

MCP

npm install && npm run build && npm start