GoKawiilKeenable launches SELECT, an MCP agent that runs SQL queries over live web data
Keenable has released SELECT, an MCP server that lets an agent query the web using DuckDB SELECT statements instead of clicking through search results. The tool combines web search and fetch operators with semantic extraction functions inside SQL, filtering pages with exact WHERE clauses before sending only surviving rows to an LLM for field extraction. Each generated report links to the full trajectory of queries, tool calls, and result sets used to build it.
GoKawiil's interpretation of the reporting above, not reported fact.
Standard web-search agents burn tokens reading full pages one at a time, which limits how many sources they can realistically process per task. By pushing filtering and aggregation into SQL before invoking an LLM, SELECT can scan over a thousand pages per query while only paying LLM costs on the rows that matter, potentially making large-scale research agents far cheaper and more scalable.
- Keenable SELECT runs read-only DuckDB queries where web search, fetch, and extraction happen as semantic SQL operators.
- Exact filters run before any LLM call, cutting the number of rows that require expensive language-model processing.
- Every generated report includes a full audit trail of the queries, tool results, and data sets behind it.
O'Reilly "Learning SQL" by Alan Beaulieu — If an agent that queries the live web with SELECT statements sounds exciting, sharpening your own SQL is the fastest way to take advantage of it. This O'Reilly guide walks through writing queries, filtering with WHERE clauses, and grouping results — exactly the skills Keenable SELECT puts to work on web data.
See O'Reilly "Learning SQL" by Alan Beaulieu on Amazon → Affiliate link — we may earn a commission on purchases, at no extra cost to you. Product picked by AI based on this article; it is not a tested recommendation.Source: keenableai.github.io, 2026-09-01
Published there as: “Keenable SELECT: an agent that searches the web in SQL”
Read the original report → The summary and analysis above are GoKawiil's own, written from reporting by the source above. Facts and quotes belong to the original publisher.