Skip to content

MCP setup for local Docker fwapg optimization #73

@NewGraphEnvironment

Description

@NewGraphEnvironment

Problem

db-newgraph MCP points at remote DB (port 63333). No MCP for the local Docker fwapg (port 5432). Optimization work (EXPLAIN ANALYZE, index recommendations, query profiling) would benefit from MCP tooling against the local DB.

Options

  1. Second MCP instance (db-local) pointed at Docker DB
  2. Parameterize the existing MCP to switch targets
  3. Skip — use psql in Docker container for ad-hoc work

Considerations

  • MCP adds 215 tools to context — two instances doubles that
  • Register/remove pattern (from db-newgraph skill) helps but still heavyweight
  • Local DB is ephemeral (docker compose down -v deletes it)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions