nightlife-mcp

MCP server for nightlife event discovery backed by Supabase.

Quick Start

Production endpoint: https://api.nightlife.dev/mcp

1. Get a free API key at nightlife.dev

2. Add to Claude Desktop config (claude_desktop_config.json):

{
  "mcpServers": {
    "nightlife": {
      "url": "https://api.nightlife.dev/mcp",
      "headers": {
        "x-api-key": "YOUR_API_KEY"
      }
    }
  }
}

For curl, TypeScript SDK, and other clients, see CLIENT_SETUP.md.

Implemented (v0.3)

• search_events

• get_tonight

• get_event_details

• search_venues

• get_venue_info

• search_performers

• get_performer_info

• log_unmet_request

• create_vip_booking_request

• get_vip_booking_status

• get_vip_table_availability

• get_vip_table_chart

• get_recommendations (v0.2, behind MCP_ENABLE_RECOMMENDATIONS=true)

• Streamable HTTP endpoint with API-key middleware

• Structured tool output schemas (outputSchema)

• Deterministic tool error payloads with stable error codes

• Runtime request/tool metrics exposed at /health

Prerequisites

• Node.js 18+

• Supabase project URL + service role key

Setup

cp .env.example .env
npm install

Set env vars in .env:

• SUPABASE_URL

• SUPABASE_SERVICE_ROLE_KEY

Optional:

• DEFAULT_CITY (default: tokyo)

• MCP_TOP_LEVEL_CITIES (default example: tokyo,san-francisco; controls available_cities in unsupported-city responses)

• DEFAULT_COUNTRY_CODE (default: JP)

• NIGHTLIFE_BASE_URL (default: https://nightlifetokyo.com)

• MCP_HTTP_REQUIRE_API_KEY (default: true)

• MCP_HTTP_USE_DB_KEYS (default: true)

• MCP_HTTP_ALLOW_ENV_KEY_FALLBACK (default: true)

• MCP_HTTP_API_KEYS (comma-separated legacy fallback keys)

• MCP_ENABLE_RECOMMENDATIONS (default: false; enables get_recommendations)

DB API Key Mode (Recommended)

HTTP authentication can use persistent API keys from Supabase plus quota tracking.

1. Run SQL migration in your Supabase SQL editor:

-- copy file contents from:
-- supabase/migrations/20260219094000_mcp_api_keys.sql

2. Ensure DB auth flags are enabled in .env:

MCP_HTTP_REQUIRE_API_KEY=true
MCP_HTTP_USE_DB_KEYS=true
MCP_HTTP_ALLOW_ENV_KEY_FALLBACK=true

3. Create an API key record:

npm run key:create -- --name claude-desktop --tier starter --daily-quota 1000 --minute-quota 60

This prints the raw api_key once. Save it securely and use it in MCP HTTP calls.

If the DB RPC is unavailable, fallback to MCP_HTTP_API_KEYS works only when MCP_HTTP_ALLOW_ENV_KEY_FALLBACK=true.

Concierge Unmet Request Backlog

Public concierge flows can log unsupported user intents to Supabase.

Run migration:

-- copy file contents from:
-- supabase/migrations/20260226_concierge_unmet_requests.sql

Then call MCP tool log_unmet_request when no good answer exists from available nightlife data.

VIP Booking Phase 1

VIP table booking submission and status tracking are backed by Supabase.

Run migration:

-- copy file contents from:
-- supabase/migrations/20260227143000_vip_phase1_requests_and_queue.sql
-- supabase/migrations/20260228124500_add_vip_booking_enabled_to_venues.sql
-- and if already deployed before 2026-02-28:
-- supabase/migrations/20260228111000_vip_outward_language_defaults.sql
-- supabase/migrations/20260301010000_vip_table_availability_chart.sql
-- supabase/migrations/20260301114000_vip_table_chart_storage_bucket.sql
-- supabase/migrations/20260303093000_vip_dashboard_admin_edits.sql

Then call MCP tools:

• create_vip_booking_request

• get_vip_booking_status

• get_vip_table_availability (read per-day table availability by venue/date range)

• get_vip_table_chart (read structured table chart with optional per-date status overlay and optional layout_image_url)

Conversation policy for create_vip_booking_request:

• Confirm booking date/time in venue local time before submitting.

• Use dual-date confirmation wording, especially for late-night arrivals (00:00-05:59).

• Required confirmation template:

  • Just to confirm: you want a table for [Night Day] night ([Night Date]), arriving around [Time] on [Arrival Day], [Arrival Date] ([Timezone]). I'll submit that as [Night Day] night with [Time] arrival. Is that correct?

• If the user gives a time like 2am without a day, ask:

  • Do you mean 2:00 AM after Thursday night (Friday morning), or after Friday night (Saturday morning)?

• If the user changes day, regenerate confirmation before submission.

Ops-tier sessions also have internal queue tools:

• list_vip_reservations (all outstanding reservations; default statuses: submitted, in_review, confirmed)

• list_vip_requests_for_alerting (due alerts only)

• mark_vip_request_alert_sent

• claim_vip_request_after_ack

• update_vip_booking_status (set confirmed/rejected/cancelled with audit event)

• upsert_vip_venue_tables (write venue table definitions + chart coordinates + optional table notes + optional layout_image_url)

• upsert_vip_table_availability (write per-date table statuses)

• upload_vip_table_chart_image (upload chart image to storage and attach layout_image_url to venue table metadata)

To discover bookable venues first, use:

• search_venues with vip_booking_supported_only=true

• or get_venue_info and check vip_booking_supported

For internal venue-booking workers, claim queue tasks via DB function:

• public.claim_next_vip_agent_task(p_agent_id text)

VIP Ops Dashboard

Internal dashboard routes:

• GET /ops/login

• POST /ops/login

• POST /ops/logout

• GET /ops/vip-dashboard

Internal admin API routes (cookie-session protected):

• GET /api/v1/admin/vip-bookings

• GET /api/v1/admin/vip-bookings/:id

• PATCH /api/v1/admin/vip-bookings/:id

Required env vars:

• VIP_DASHBOARD_ADMINS (comma-separated username:password pairs)

Optional env vars:

• VIP_DASHBOARD_SESSION_TTL_MINUTES (default: 720)

• VIP_DASHBOARD_SESSION_COOKIE_NAME (default: vip_dashboard_session)

Run

Stdio (local desktop clients):

npm run dev

Streamable HTTP:

npm run dev:http

For production build:

npm run build
npm start

For HTTP in production:

npm run start:http

Authenticated production smoke check:

NLT_API_KEY=... npm run smoke:prod:auth

Optional env overrides:

• NLT_MCP_URL (default: https://api.nightlife.dev/mcp)

• NLT_REST_BASE_URL (default: https://api.nightlife.dev/api/v1)

• NLT_SMOKE_CITY (default: tokyo)

Debug web UI for recommendations:

MCP_ENABLE_RECOMMENDATIONS=true npm run dev:http
# open http://127.0.0.1:3000/debug/recommendations

Notes

• Date handling supports tonight, this_weekend, YYYY-MM-DD, and YYYY-MM-DD/YYYY-MM-DD.

• get_recommendations returns up to 10 diverse modal slots with dynamic city-aware fallback.

• Venue and performer tools include upcoming events snapshots.

• log_unmet_request writes unresolved user asks to public.concierge_unmet_requests.

• VIP phase 1 writes booking submissions to public.vip_booking_requests and worker queue tasks to public.vip_agent_tasks.

• VIP inventory writes table definitions to public.vip_venue_tables and date-specific statuses to public.vip_table_availability.

• search_venues and get_venue_info include vip_booking_supported so clients can show exactly which venues accept VIP booking submissions.

• vip_booking_supported is sourced from public.venues.vip_booking_enabled (separate from guest_list_enabled).

• create_vip_booking_request only accepts venues where vip_booking_supported=true.

• City handling is backed by public.cities (slug, timezone, and service-day cutoff).

• Supported top-level cities are environment-configurable (for example tokyo and san-francisco) while Tokyo can remain the default.

• Stdio transport: no API key check.

• HTTP transport (/mcp): API key required by default (MCP_HTTP_REQUIRE_API_KEY=true).

• API key headers:

  • Authorization: Bearer <key>

  • x-api-key: <key>

• HTTP responses include key tier/source and rate-limit headers when DB-backed auth is active:

  • X-API-Key-Tier

  • X-API-Key-Source

  • X-RateLimit-Daily-Limit

  • X-RateLimit-Daily-Remaining

  • X-RateLimit-Minute-Limit

  • X-RateLimit-Minute-Remaining

• Health endpoint: /health.

• Debug page for manual tool testing: /debug/recommendations.

• Tool errors are returned as JSON text payloads in result.content[0].text:

  • INVALID_DATE_FILTER

  • INVALID_EVENT_ID

  • UNSUPPORTED_EVENT_ID

  • EVENT_NOT_FOUND

  • INVALID_VENUE_ID

  • VENUE_NOT_FOUND

  • INVALID_PERFORMER_ID

  • PERFORMER_NOT_FOUND

  • INVALID_BOOKING_REQUEST

  • BOOKING_REQUEST_NOT_FOUND

  • BOOKING_STATUS_UPDATE_FAILED

  • VIP_TASK_NOT_AVAILABLE

  • VIP_ALERT_UPDATE_FAILED

  • VIP_CLAIM_FAILED

  • INVALID_REQUEST

  • REQUEST_WRITE_FAILED

  • DB_QUERY_FAILED

  • INTERNAL_ERROR