Click any tag below to further narrow down your results
Links
xlDuckDb is an Excel add-in that lets you write DuckDB SQL queries directly in spreadsheet cells and get results back as normal Excel data. You can query Excel ranges, JSON files, CSV files, Parquet files, and even remote data on HTTPS or AWS S3.
- The add-in works with Excel ranges, named ranges, and tables using simple syntax like =DuckDbQuery(A27,,A1:E25), plus you can query multiple ranges in a single query by passing them as separate arguments.
- DuckDB handles messy data formats automatically—it auto-detects CSV delimiters and data types, extracts nested JSON with JSONPath syntax, and efficiently queries large Parquet files that don't fit in memory.
- You can join data across multiple file types in one SQL query (e.g., combining JSON and CSV data with a CTE and INNER JOIN), making it possible to correlate disparate datasets without leaving Excel.
Keenable SELECT is an MCP server that lets agents query the web directly using SQL, combining web search and semantic extraction into single queries instead of reading through individual pages. It handles the filtering and data extraction server-side, reducing the LLM token cost of web research.
- Instead of returning ten links for an agent to read, SELECT runs one query across 1,000+ pages, filters with exact WHERE clauses, and extracts fields with a single LLM call per matching row.
- The system uses semantic operators (WEB_SEARCH, WEB_FETCH, SEM_EXTRACT, SEM_MATCH) embedded directly in SQL statements, which the server parses and executes before returning results as plain columns.
- Research agents use the select tool to iteratively write and run queries until they answer a question, then generate shareable HTML reports via a second agent that builds the page from structured result sets.