Misc MCP Server — Tools

Current tools in misc_mcp_server.py. All prefixed [misc store] in descriptions. Each tool description includes a notes key so the LLM can look up detailed usage — see MCP conventions.

hello

Returns the string "hello". Placeholder tool — demonstrates the server is working and connected. No arguments.

pg_query

Executes a read-only SELECT against the OwnTracks PostgreSQL location database on gravlax. Returns up to 500 rows as JSON.

Architecture: asyncpg persistent pool (min=1, max=3) created at process startup. Connects as owntracks_ro (SELECT-only). Full details: location-db/architecture.

Usage and PostGIS query examples: location-db/usage.

Schema reference: location-db/schema.

If the tool returns an error ending in "Please try again" — the pool connection was stale. Simply retry the query.

Future Ideas

(Add ideas here as they arise.)