MCP Server - Internal SQL Bridge

MCP Protocol

SSE & REST

Standard Model Context Protocol

Database Engine

SQLITE

6 Internal Tables Loaded

Internal VM Access

Network Port 8000

Private VPC IP Connectivity

🔌 Cara Menghubungkan Aplikasi Lain / Gemini Enterprise

Gunakan endpoint berikut dari VM lain dalam network/VPC yang sama:

1. Model Context Protocol (MCP) SSE Connection:

SSE Endpoint URL   : http://<IP_VM_INI>:8000/sse
Message Endpoint   : http://<IP_VM_INI>:8000/messages/

2. Test Koneksi via Curl:

# Cek Health status
curl -s http://<IP_VM_INI>:8000/health

# List Tools yang tersedia
curl -s http://<IP_VM_INI>:8000/api/tools

# Eksekusi Query SQL langsung via HTTP REST
curl -X POST http://<IP_VM_INI>:8000/api/tools/call \
  -H "Content-Type: application/json" \
  -d '{"name": "query_sql", "arguments": {"query": "SELECT full_name, email, department FROM employees LIMIT 3"}}'

📊 Tabel Database Internal Aktif

Nama Tabel	Jumlah Baris	Kolom Contoh
`departments`	5	`id, dept_code, dept_name, head_of_department, office_floor...`
`employees`	10	`id, nik, full_name, email, department...`
`internal_documents`	4	`id, doc_id, title, category, department...`
`internal_faqs`	3	`id, category, question, answer, keywords`
`internal_projects`	4	`id, project_code, project_name, department, lead_person...`
`it_assets`	4	`id, asset_tag, asset_type, model, assigned_to_nik...`

🛠️ Tools MCP yang Tersedia