- Introduced the MCP server with core functionality for handling document upserts and searches using the pgvecter API.
- Added configuration management for API keys and base URL.
- Implemented RPC request handling for various tools, including dev log and trade event management.
- Expanded the README with endpoint details and usage examples for the new MCP server features.
- Created documentation for development notes and API specifications in `docs/mcp_dev_memo.md`.
- Added necessary types and client implementations for interacting with the pgvecter API.
- Added support for multiple collections in `KbSearchRequest` with validation logic in `main.go`.
- Updated `openapi.yaml` to reflect the new `collections` field and its requirements.
- Strengthened collection constraints in the database with a new migration script.
- Expanded `README.md` with examples for using the new collections feature.
- Enhanced `main.go` with new types and handlers for managing collections and upserting documents, including validation and error handling.
- Updated `openapi.yaml` to define new endpoints for listing collections and admin access.
- Introduced `CollectionsResponse` and `CollectionItem` schemas for API responses.
- Added a new migration script to include a `collection` column in the `kb_doc_chunks` table.
- Expanded `README.md` with usage examples for the new collection features and environment variable configurations.
- Enhanced `README.md` to include additional environment variable requirements and startup instructions.
- Updated `design.md` with detailed API design drafts, use cases, and security considerations for the pgvecter API, including metadata handling and SQL safety measures.
- Introduced `main.go` implementing API key creation, listing, updating, and revocation.
- Added `go.mod` and `go.sum` for dependency management.
- Created `migrations/001_create_api_keys.sql` for setting up the API keys table in PostgreSQL.
- Updated `openapi.yaml` to include new endpoints for managing API keys.
- Added documentation for the admin UI and API key management in `docs/admin_ui.md` and `docs/design.md`.
- Enhanced `README.md` with environment variable requirements and startup instructions.
- Created `openapi.yaml` defining API endpoints for health check, SQL query, document upsert, and vector search.
- Added `design.md` outlining API purpose, use cases, and initial design drafts.
- Introduced `filter_builder.py` for constructing SQL WHERE clauses from JSON filter objects, supporting various operators for metadata queries.
