NHT DWH MCP Server

Connect your AI agent to the NHT BI data warehouse. Read-only access to dimensional tables, financial aggregates, and trading data — with DLP-filtered responses.

Get your API token

Sign in with your NHT Identity account to get a personal access token.

Open the link below and enter this code:

—
Login with NHT Identity ↗
Waiting for authorization…
✓ Authenticated — offline token ready

Paste this into your MCP client as a Bearer token. This token does not expire.

About

This MCP server exposes the NHT BI data warehouse (PostgreSQL) to AI agents over the Model Context Protocol. All access is read-only; row values are screened by a two-layer DLP pipeline (catalogue-driven column redaction plus runtime NER) before they leave the server.

Tools

  • list_tables — paginated table catalogue (members of confirmed partitioned families are hidden; query the base table with a partition-key filter)
  • list_columns — columns, types, and DLP flags for a single table
  • query — row-level reads with a Lucene-style filter syntax
  • aggregate — group/aggregate/period summaries with HAVING
  • multi_query — batch query / aggregate calls with bounded concurrency

Connecting

MCP-compatible clients

Point your client at the endpoint below and supply the token from the “Get Token” panel as a Bearer token.

https://dwh.mcp.nht.io/mcp

curl

curl -X POST https://dwh.mcp.nht.io/mcp \
  -H "Authorization: Bearer YOUR_TOKEN" \
  -H "Content-Type: application/json" \
  -H "Accept: application/json, text/event-stream" \
  -d '{"jsonrpc":"2.0","method":"tools/list","id":1}'

Your token

The token returned by the “Get Token” flow is an offline refresh token — long-lived and revocable from Keycloak. Treat it like a password.