Skip to main content
Glama
SirojWongpitakroj

MHTL Warehouse MCP Server

by SirojWongpitakroj
OverviewSchemaRelated ServersScoreDiscussions
JavaScript
Local

MHTL Warehouse MCP Server

An MCP server (TypeScript) that lets Claude query the local DuckDB warehouse in data/mock.duckdb — a mock motorcycle-loan warehouse with DMS (loan servicing) and LOS (loan origination) tables.

Ask Claude things like:

"Get the insights of the customer Noy Vongphachanh"

and it will look the customer up, pull their contracts, delinquency/NPL status, recent collection notes, and loan applications.

Tools exposed

Tool

What it does

list_tables

List all tables/views with row counts.

describe_table

Show columns + types for a table.

find_customer

Search customers by (partial) name or id → returns their oid.

customer_insights

The headline tool. Full profile for a customer: identity, contracts, outstanding/overdue balances, NPL flag, recent contact notes, loan applications.

query

Run an arbitrary read-only SELECT/WITH query. Auto-applies a LIMIT; blocks anything that writes.

The database is opened read-only, and the query tool rejects any non-SELECT statement and multi-statement input, so nothing can mutate the data.

Related MCP server: SQLite MCP Server

Setup

npm install
npm run build      # compiles src/ -> dist/

Connect it to Claude Desktop

  1. Build (npm run build).

  2. Copy claude_desktop_config.json from this folder to Claude Desktop's config location (create the folder/file if it doesn't exist):

    • Windows: %APPDATA%\Claude\claude_desktop_config.json (C:\Users\fookl\AppData\Roaming\Claude\claude_desktop_config.json)

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

    If you already have other MCP servers configured, merge the mhtl-warehouse entry into your existing mcpServers object instead of overwriting the file.

  3. Fully quit and reopen Claude Desktop.

  4. In a new chat you should see the tools available (plug/tools icon). Try: "Get the insights of the customer Noy Vongphachanh."

How the data links together

  • dms_customer.oid (BIGINT) ← dms_contract.customer (the numeric id).

  • dms_contract.contractid ← dms_contact_note.contract / dms_contact_legal.contract.

  • LOS ↔ DMS customers share their last 5 id digits 1:1 (C500123 ↔ L100123), used to attach loan applications.

Configuration

  • WAREHOUSE_DB_PATH — absolute path to the DuckDB file. If unset, the server defaults to ../data/mock.duckdb relative to dist/.

Project layout

src/index.ts   MCP server + tool definitions
src/db.ts      Read-only DuckDB connection + query/normalisation helpers
dist/          Compiled output (run this)
data/          mock.duckdb + parquet warehouse
Install Server
F
license - not found
A
quality
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.

Tools

Related MCP Servers

  • MCP Database Server

    msathiyakeerthi
    A
    license
    -
    quality
    C
    maintenance
    Provides database access capabilities to Claude with support for both SQLite and SQL Server databases. It enables users to manage schemas, execute SQL queries, and export results through natural language interaction.
    Last updated
    980
    MIT

  • SQLite MCP Server

    sparxit
    A
    license
    -
    quality
    D
    maintenance
    Enables natural language interaction with local SQLite databases through Claude Desktop, translating plain English queries into SQL for data analysis and exploration.
    Last updated
    3
    MIT

  • motherduck-mcp

    denizguzeloglu
    A
    license
    -
    quality
    D
    maintenance
    Enables executing SQL queries on DuckDB databases locally or on MotherDuck cloud, with support for multiple databases, read-only mode, and Claude Desktop integration.
    Last updated
    MIT

View all related MCP servers

Related MCP Connectors

  • Corebee AI Customer Support

    Run AI customer support from your terminal: conversations, knowledge base, and chat widget.

  • Nevent MCP

    Talk to your live-events CRM (campaigns, analytics, paid ads, segments) in Claude and ChatGPT.

  • Foundry/API

    Bounded tools for rendering, extraction, RAG, enrichment, local discovery and review analysis.

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/SirojWongpitakroj/ClaudeMCPServerTest'

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