feat: implement MCP server for real estate database search
...
Add streamable-http MCP server with 4 tools:
- search_similar_listings: vector search via pgvector+HNSW (cosine)
- search_by_metadata: full-text search via FTS (ukrainian config)+GIN
- get_listing_by_id: fetch single listing by ID
- describe_schema: static schema documentation for AI agent
Features:
- asyncpg read-only pool with default_transaction_read_only
- parameterized queries + query safety check (multi-statement block)
- Pydantic models for input validation and JSON serialization
- Ollama nomic-embed-text client with dimension validation
- Error handling: Ollama/DB/validation exceptions wrapped in JSON
- Docker & docker-compose support
- ruff clean + 8 pytest tests passing
Co-Authored-By: Claude <noreply@anthropic.com>
Eugene Sukhodolskiy
committed
1 day ago