Which integrations are available for this server?

Provides tools for querying and managing a PostgreSQL database (bankdb), including listing customers, retrieving customer details and transactions, and upserting customer or branch records into dedicated tables.

How do I use bank-postgres-mcp?

1. Click on "Deploy Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@bank-postgres-mcp show me all transactions for account DB5194542004" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

bank-postgres-mcp

HTTP MCP server that reads from and writes to a PostgreSQL database (bankdb). Deployed and accessible at: https://armored-backspace-angles.ngrok-free.dev/mcp

Endpoints

Path	Method	Purpose
`/mcp`	POST	MCP Streamable HTTP endpoint
`/health`	GET	Liveness check

Related MCP server: db-mcp

Tools

Read tools (query `bankdb` directly)

Tool	Description
`list_customers`	List all customers in the database
`get_customer_by_id`	Get customer profile + all accounts by customer_id
`get_customer_by_account`	Look up customer + account by account number (e.g. `DB5194542004`)
`get_transactions`	Get recent transactions by account_id or account_number

Write tools (upsert into MCP dump tables)

Tool	Action
`dump_customer_data`	Upsert a fetched customer record into `customers`
`dump_created_customer`	Insert a newly created customer into `customers`
`dump_bank_branch`	Upsert a bank branch record into `bank_branches`

Tables are auto-created on first use.

Setup

1. Prerequisites

Node.js ≥ 18
PostgreSQL running locally

2. Install & build

cd bank-postgres-mcp
npm install
npm run build

3. Configure environment

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

Provided credentials:

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

4. Start the server

# 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

Server starts on http://localhost:3100 by default. Override with PORT=XXXX.

5. Verify

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

Registering in watsonx Orchestrate

In Orchestrate, add a new MCP Server tool integration:

Field	Value
Transport	Streamable HTTP
URL	`http://localhost:3100/mcp`

If Orchestrate is running remotely (not on your laptop), expose the server with a tunnel:
npx localtunnel --port 3100
# Use the returned https URL instead of localhost

Registering in Bob (`.bob/mcp.json`)

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

Database schema

`customers`

Column	Type	Notes
`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	`fetch` or `create`
`inserted_at`	TIMESTAMPTZ	auto
`updated_at`	TIMESTAMPTZ	auto

`bank_branches`

Column	Type	Notes
`ifsc`	TEXT PK
`branch_name`	TEXT
`bank_name`	TEXT
`city`	TEXT
`state`	TEXT
`services`	TEXT[]
`inserted_at`	TIMESTAMPTZ	auto
`updated_at`	TIMESTAMPTZ	auto

This server cannot be deployed

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Maintenance

ActivitySlowing

ResponsivenessNo issues

Resources

GitHub Repository

Need Help?

Related Servers

Related MCP Connectors

modern-treasury A
io.usefulapi
MCP server for Modern Treasury — payment orders, transactions, counterparties and ledgers.
Finance Payments & Billing
172
mcpOAuth
io.prisma
MCP server for managing Prisma Postgres.
Databases Developer Tools
249
thoughtsOAuth
ai.thoughtbox.api
An MCP server that provides read access to your cloud storage providers, bank accounts and more.
Cloud Storage Finance
2
SupabaseOAuth
com.supabase
MCP server for interacting with the Supabase platform
Cloud Platforms Databases Developer Tools
32,924

Related MCP Servers

MCP Banking Server
Finance Payments & Billing
shreyash1231
F
license
Not graded
quality
D
maintenance
A minimal banking system MCP server that allows account management, deposits, withdrawals, balance inquiries, and transaction history via REST endpoints.
Updated 9 months ago (2025-12-27 18:13 UTC)
-
db-mcp
Databases Developer Tools
zhusinian
A
license
A
quality
D
maintenance
A lightweight MCP server for relational databases, enabling dynamic connections to PostgreSQL and MySQL, SQL execution, and transaction control.
Updated 4 months ago (2026-06-13 02:44 UTC)
7
57 npm
1
MIT
PostgreSQL MCP Server
Databases Monitoring
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.
Updated 3 months ago (2026-06-18 20:16 UTC)
36
8 npm
MIT
postgres-mcp
Databases Developer Tools
jmluque72
A
license
Not graded
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.
Updated a year ago (2025-08-16 07:49 UTC)
1,239 npm
MIT