Skip to main content
Glama
deenesjakoruzh
prashil1996

bank-postgres-mcp

by prashil1996
OverviewSchemaRelated ServersScoreDiscussions
JavaScript
Hybrid

bank-postgres-mcp

Servidor HTTP MCP que lee y escribe en una base de datos PostgreSQL (bankdb). Desplegado y accesible en: https://armored-backspace-angles.ngrok-free.dev/mcp

Endpoints

Ruta

Método

Propósito

/mcp

POST

Punto de enlace HTTP MCP transmisible

/health

GET

Verificación de actividad

Related MCP server: db-mcp

Herramientas

Herramientas de lectura (consultan bankdb directamente)

Herramienta

Descripción

list_customers

Lista todos los clientes en la base de datos

get_customer_by_id

Obtiene perfil del cliente + todas las cuentas por customer_id

get_customer_by_account

Busca cliente + cuenta por número de cuenta (ej. DB5194542004)

get_transactions

Obtiene transacciones recientes por account_id o account_number

Herramientas de escritura (insertan o actualizan en tablas de volcado MCP)

Herramienta

Acción

dump_customer_data

Inserta o actualiza un registro de cliente obtenido en customers

dump_created_customer

Inserta un cliente recién creado en customers

dump_bank_branch

Inserta o actualiza un registro de sucursal bancaria en bank_branches

Las tablas se crean automáticamente en el primer uso.

Configuración

1. Prerrequisitos

  • Node.js ≥ 18

  • PostgreSQL ejecutándose localmente

2. Instalar y compilar

cd bank-postgres-mcp
npm install
npm run build

3. Configurar el entorno

cp env.example .env
# .env is gitignored — edit credentials there

Credenciales proporcionadas:

DATABASE_URL=postgresql://bankuser:bankpassword@localhost:5432/bankdb
POSTGRES_HOST=localhost
POSTGRES_PORT=5432
POSTGRES_DB=bankdb
POSTGRES_USER=bankuser
POSTGRES_PASSWORD=bankpassword

4. Iniciar el servidor

# Export env vars, then start
export DATABASE_URL=postgresql://bankuser:bankpassword@localhost:5432/bankdb
node build/index.js

# Or with all vars:
export POSTGRES_HOST=localhost POSTGRES_PORT=5432 POSTGRES_DB=bankdb \
       POSTGRES_USER=bankuser POSTGRES_PASSWORD=bankpassword
node build/index.js

El servidor se inicia en http://localhost:3100 por defecto. Sobrescribir con PORT=XXXX.

5. Verificar

curl http://localhost:3100/health
# → {"status":"ok","server":"bank-postgres-mcp","version":"1.0.0"}

Registro en watsonx Orchestrate

En Orchestrate, añade una nueva integración de herramienta Servidor MCP:

Campo

Valor

Transporte

HTTP Streamable

URL

http://localhost:3100/mcp

Si Orchestrate se ejecuta de forma remota (no en tu portátil), expón el servidor con un túnel:

npx localtunnel --port 3100
# Use the returned https URL instead of localhost

Registro en Bob (.bob/mcp.json)

{
  "mcpServers": {
    "bank-postgres-mcp": {
      "url": "http://localhost:3100/mcp"
    }
  }
}

Esquema de la base de datos

customers

Columna

Tipo

Notas

customer_id

TEXT PK

full_name

TEXT

date_of_birth

TEXT

phone

TEXT

email

TEXT

pan

TEXT

PII

aadhaar

TEXT

PII

account_number

TEXT

PII

ifsc

TEXT

address_*

TEXT

line1, line2, city, state, postal_code, country

account_type

TEXT

kyc_status

TEXT

available_balance

NUMERIC

credit_score

INT

nominee

TEXT

source

TEXT

obtenido o creado

inserted_at

TIMESTAMPTZ

automático

updated_at

TIMESTAMPTZ

automático

bank_branches

Columna

Tipo

Notas

ifsc

TEXT PK

branch_name

TEXT

bank_name

TEXT

city

TEXT

state

TEXT

services

TEXT[]

inserted_at

TIMESTAMPTZ

automático

updated_at

TIMESTAMPTZ

automático

This server cannot be installed

F
license - not found
-
quality - not tested
C
maintenance

How are these scores calculated?

Maintenance

–Maintainers
–Response time
–Release cycle
–Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Related MCP Servers

  • MCP Banking Server

    shreyash1231
    F
    license
    -
    quality
    D
    maintenance
    A minimal banking system MCP server that allows account management, deposits, withdrawals, balance inquiries, and transaction history via REST endpoints.

  • db-mcp

    zhusinian
    A
    license
    A
    quality
    C
    maintenance
    A lightweight MCP server for relational databases, enabling dynamic connections to PostgreSQL and MySQL, SQL execution, and transaction control.
    7
    51
    1
    MIT

  • PostgreSQL MCP Server

    foxter-io
    A
    license
    A
    quality
    C
    maintenance
    Full-featured MCP server that exposes 36 tools for interacting with PostgreSQL databases, covering schema introspection, query execution, data exploration, performance monitoring, security auditing, and maintenance.
    36
    11
    MIT

  • postgres-mcp

    jmluque72
    A
    license
    -
    quality
    D
    maintenance
    MCP server for PostgreSQL that enables Cursor and other MCP clients to execute SQL queries, list tables, and explore database schemas via HTTP.
    505
    MIT

View all related MCP servers

Related MCP Connectors

  • mcp

    MCP server for managing Prisma Postgres.

  • Supabase

    MCP server for interacting with the Supabase platform

  • postman-mcp-server

    A basic MCP server to operate on the Postman API.

View all MCP Connectors

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/prashil1996/github-postgres-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server