Skip to main content
Glama
mhdarifsetiawan01

mcp-dummy-server

by mhdarifsetiawan01
OverviewSchemaRelated ServersScoreDiscussions
JavaScript
Hybrid

mcp-dummy-server

MCP server dengan data dari PostgreSQL, transport Streamable HTTP mode stateless — cocok untuk multi-instance/replica di Fly.io.

Struktur

src/
  data/
    db.js                  # koneksi pool PostgreSQL (pg)
    hariRepository.js      # query ke tabel `hari`
    kodeposRepository.js   # query ke tabel `kodepos`
    apiKeysRepository.js   # auth: bcrypt.compare ke tabel `api_keys`
  tools/
    index.js               # definisi & registrasi semua MCP tools
  server.js                # express + StreamableHTTPServerTransport + auth middleware
db/
  migrations/
    001_create_tables.sql  # schema: hari, kodepos, api_keys
  seed.js                  # isi data awal (jalankan sekali setelah db:up)
docker-compose.yml         # Postgres 16-alpine lokal, port 5435

Pindah Provider DB (Dinamis): Cukup ganti nilai DATABASE_URL di .env (Docker Lokal ↔ Supabase ↔ Neon ↔ Fly Postgres) tanpa perlu mengubah kode sumber sama sekali.

Related MCP server: Homelab MCP starter

Tools yang tersedia

Tool

Input

Fungsi

list_hari

-

Semua hari Senin-Minggu

get_hari

id (1-7)

Detail 1 hari

list_kodepos

-

Semua data kodepos

search_kodepos_by_kota

kota (string)

Cari kodepos berdasarkan nama kota

get_kodepos

kodepos (5 digit)

Detail exact match kodepos

Jalan lokal (dengan Postgres via Docker)

npm install
cp .env.example .env   # isi MCP_API_KEY, sesuaikan DATABASE_URL dll.

# 1. Jalankan Postgres Docker (port 5435 — hindari conflict 5432/5433/5434)
npm run db:up

# 2. Seed: buat tabel + isi data awal + hash API key ke DB
npm run db:seed

# 3. Jalankan server
npm start
# server listen di http://localhost:8080/mcp

Test cepat:

curl -X POST http://localhost:8080/mcp \
  -H "Content-Type: application/json" \
  -H "Accept: application/json, text/event-stream" \
  -H "x-api-key: $(grep MCP_API_KEY .env | cut -d= -f2)" \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/list","params":{}}'

Stop Postgres:

npm run db:down

Auth

Server dilindungi API key berbasis database (tabel api_keys, key disimpan sebagai bcrypt hash — tidak pernah plaintext).

  • Kalau DATABASE_URL tidak di-set → auth otomatis nonaktif (dev mode), muncul warning di log. Jangan biarkan di production.

  • Kalau DATABASE_URL di-set → semua request ke /mcp wajib bawa header x-api-key yang cocok (diverifikasi via bcrypt.compare ke DB).

  • last_used_at di tabel api_keys otomatis diupdate setiap kali key dipakai (fire-and-forget).

Jalankan lokal dengan auth aktif:

# Pastikan DATABASE_URL sudah di-.env dan db:seed sudah dijalankan
MCP_API_KEY=<your-key> npm start

Deploy ke Fly.io

# install flyctl kalau belum: https://fly.io/docs/flyctl/install/
fly auth login

# dari folder project ini
fly launch --no-deploy   # generate app, JANGAN overwrite fly.toml yang sudah ada

# WAJIB: set secrets (jangan taruh di fly.toml / git)
fly secrets set MCP_API_KEY="ganti-dengan-string-random-yang-panjang"
fly secrets set DATABASE_URL="postgresql://user:pass@host:5432/dbname"

fly deploy

Catatan: Untuk production, gunakan Postgres yang dihosting (mis. Fly Postgres, Supabase, Neon). Jalankan npm run db:seed sekali saja terhadap DB production untuk inisialisasi tabel dan API key pertama.

Setelah deploy, endpoint MCP ada di:

https://<nama-app-kamu>.fly.dev/mcp

Konek dari Antigravity IDE

{
  "mcpServers": {
    "dummy-data-mcp": {
      "url": "https://<nama-app-kamu>.fly.dev/mcp",
      "headers": {
        "x-api-key": "ganti-dengan-string-random-yang-panjang"
      }
    }
  }
}

Kalau Antigravity IDE hanya mendukung MCP via stdio, pakai proxy mcp-remote:

{
  "mcpServers": {
    "dummy-data-mcp": {
      "command": "npx",
      "args": [
        "-y", "mcp-remote", "https://<nama-app-kamu>.fly.dev/mcp",
        "--header", "x-api-key:ganti-dengan-string-random-yang-panjang"
      ]
    }
  }
}

Manajemen API Key

API key disimpan di tabel api_keys sebagai bcrypt hash. Untuk menambah key baru:

# Contoh: tambah key baru langsung ke DB
node -e "
import('bcrypt').then(async ({default: bcrypt}) => {
  const hash = await bcrypt.hash('key-baru-kamu', 12);
  console.log('INSERT INTO api_keys (key_hash, label) VALUES (\'' + hash + '\', \'nama-label\');');
});
"
# Salin output INSERT-nya, jalankan di psql atau DB client

Catatan keamanan

  • API key tidak pernah disimpan plaintext — hanya bcrypt hash di DB.

  • MCP_API_KEY di .env hanya dipakai saat db:seed (untuk generate hash pertama kali). Selebihnya tidak dipakai server.

  • Untuk revoke key: UPDATE api_keys SET is_active = false WHERE id = <id>;

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

View all related MCP servers

Related MCP Connectors

  • postman-mcp-server

    A basic MCP server to operate on the Postman API.

  • IBGE Brasil MCP

    MCP server for live, sourced Brazilian public data from the official IBGE APIs.

  • server

    An MCP server that let you interact with Cycloid.io Internal Development Portal and Platform

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/mhdarifsetiawan01/semantic-mcp-server'

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