About Adp Bank Demo
Adp Bank Demo is an MCP server in the Healthcare category: redpanda ADP conference demo — Bank Internal MCP server + AI agent. It has been installed 0 times through Conduid.
Install
git clone https://github.com/joshblakeley/adp-bank-demoThis server has no ConduID identity, so agent calls to it are not receipted. Pin the version you install and review the source before granting it credentials.
Ask AI
Ask AI about Adp Bank Demo
Powered by Claude · Grounded in docs
Security checks
- ·README presentNot checked yet.
- ·License declaredNot checked yet.
- ·Tests presentNot checked yet.
- ·Dependencies pinnedNot checked yet.
- ·No dynamic code executionNot checked yet.
- ·Scoped permissionsNot checked yet.
README
ADP Bank Demo
Conference demo showcasing Redpanda's Agentic Data Plane (ADP) — an internal bank employee tool that lets staff look up customers, check account balances, and investigate overdrafts using natural language.
What's in this repo
| File | Description |
|---|---|
2026-04-01-bank-demo-mcp-design.md |
Full design spec — MCP server tools, data model, architecture, implementation steps |
bank-demo-seed.sql |
Postgres schema DDL + mock seed data (10 customers, ~30 days of transactions) |
restore/ |
Shell scripts to recreate all Redpanda Cloud objects if the cluster is wiped |
server.js + public/ |
PandaBank web chat UI — run with npm start, open http://localhost:3000 |
Architecture
ADP Agent (Claude)
│ natural language
▼
"Bank Internal Assistant" AI Agent
│ MCP over HTTPS
▼
"Bank Internal" MCP Server (Redpanda Cloud, adp-production)
│ sql_raw processors
▼
AWS RDS Postgres (us-east-2, db: bank_demo)
│
▼
Mock seed data (bank-demo-seed.sql)
MCP Tools
| Tool | Purpose |
|---|---|
get_customer |
Look up a customer by name (partial match) — returns customer details + account IDs |
get_account_balance |
Get balance and overdraft status for an account (healthy / low / overdrawn / overdraft_exceeded) |
get_recent_transactions |
Get recent transactions for an account, sorted newest first |
Demo Queries
- "Look up customer Alice Johnson and show me her accounts."
- "What is the balance on account 3? Is it overdrawn?"
- "Show me the last 5 transactions on account 7."
- "Which of Sarah Miller's accounts are in overdraft?"
- "Why is Bob Martinez overdrawn? Walk me through his recent activity."
Infrastructure
- Cluster:
adp-production(BYOC, AWS us-east-2) — cluster IDd6kjl4h19241bg3ek3h0 - MCP Server ID:
d76lq0o5s2pc73bj5ua0 - AI Agent ID:
d76o3ig5s2pc73bj5uag - RDS endpoint:
joshb-adp-demo.c3uaqo244uj7.us-east-2.rds.amazonaws.com - Redpanda secret:
BANK_DEMO_DSN(scopes:SCOPE_REDPANDA_CONNECT,SCOPE_MCP_SERVER)
Re-creating from scratch
If starting fresh, first spin up RDS:
- Spin up RDS Postgres
db.t3.microinus-east-2, databasebank_demo - Enable "Publicly accessible" and add an inbound TCP 5432 rule for the Redpanda NAT gateway
3.138.236.26
Then run the restore scripts in order (requires rpk CLI authenticated via rpk cloud login):
cd restore/
RDS_HOST=<your-rds-endpoint> RDS_PASS=<your-password> ./01-seed-database.sh
RDS_HOST=<your-rds-endpoint> RDS_PASS=<your-password> ./02-create-secret.sh
./03-create-mcp-server.sh # prints new MCP_SERVER_ID
./04-create-service-account.sh # prints new SERVICE_ACCOUNT_SECRET
MCP_SERVER_ID=<id-from-step-3> SERVICE_ACCOUNT_SECRET=<secret-from-step-4> ./05-create-agent.sh
See restore/README.md for full details. No tokens or secrets are hardcoded — all credentials are passed as environment variables or fetched at runtime via rpk.
README mirrored from the source repository 5 months ago. The original is authoritative.