Hacker News
Keenable SELECT: an agent that searches the web in SQL
Keenable SELECT is an MCP server that enables an LLM to execute DuckDB SELECT statements on live web data using operators like WEB_SEARCH, WEB_FETCH, and SEM_EXTRACT. Query results are stored with an ID for later SQL access, automated HTML report creation, and iterative refinement in a sandboxed Python environment. The system can search thousands of pages, apply precise WHERE clauses, and generate shareable reports while keeping LLM token usage low.