Get data into your AI
Load files and tables of any size once; your AI queries them as often as it likes.
- My CSV is too large for ChatGPT to analyse. What can I do?
Chat assistants analyse uploaded files in a sandbox with limited memory and time, so a large CSV gets cut short or fails. Load the file into a database your AI can query...
- How do I give an AI assistant access to millions of rows of data?
Put the data in a database and connect your assistant to it over MCP. The assistant then lists the tables, reads their columns, and sends queries that run over all the rows, so...
- How do I let Claude query a CSV file on my computer?
Sync the folder with the CSV to an mcpdata instance with `cdb-localdata`, and connect Claude to that instance. Claude then queries the file as a table. The file is only read,...
- How do I turn a folder of CSV files into tables my AI can query?
Point `cdb-localdata` at the folder: every CSV becomes a table named after the file, under a namespace you choose (`shop.orders`, `shop.customers`, ...). Your AI lists them...
- How do I load Parquet files so an AI can query them?
Sync the folder with `cdb-localdata`, the same as CSV: each `.parquet` file becomes a table, with its column types kept. Your AI queries it over MCP with exact results. ORC...
- How do I load an Excel workbook into a database my AI can use?
Sync the folder with the workbook using `cdb-localdata`: each sheet becomes a table named `<namespace>.<file>.<sheet>`. Your AI then queries the sheets like any table, over all...
- How do I load every sheet of an Excel file as separate tables?
`cdb-localdata` does it by default: every sheet of every workbook in the folder becomes its own table, `<namespace>.<file>.<sheet>`. Sync once and your AI sees one table per sheet.
- How do I keep a daily snapshot of a CSV export so my AI can compare days?
Save each day's export with its date in the file name in one folder, and mark that folder as a history folder. `cdb-localdata` then loads every file as a dated version of a...
- How do I upload a pandas DataFrame so Claude can query it?
Write it with the `cdb` client: `s.write_table("name", df)`. It becomes a table Claude can query over MCP straight away, and `replace=True` swaps in a new version later while...
- How do I give Claude a persistent memory table?
Let Claude create its own table with the `create_table` tool (names under `agent.*`) and add to it with `append_rows`. What it writes is still there in the next conversation,...