Answers
Questions people ask their AI about data. Every answer is a recipe we run against a live instance, with the date it last passed.
Get data into your AI
- My CSV is too large for ChatGPT to analyse. What can I do?
- How do I give an AI assistant access to millions of rows of data?
- How do I let Claude query a CSV file on my computer?
- How do I turn a folder of CSV files into tables my AI can query?
- How do I load Parquet files so an AI can query them?
- How do I load an Excel workbook into a database my AI can use?
- How do I load every sheet of an Excel file as separate tables?
- How do I keep a daily snapshot of a CSV export so my AI can compare days?
- How do I upload a pandas DataFrame so Claude can query it?
- How do I give Claude a persistent memory table?
Report with AI
- How do I get Claude to make a weekly sales report from my data?
- How do I email a report every Monday morning automatically?
- How do I get an AI to make a chart from my data?
- How do I pivot data by month and region with AI?
- How do I export a report as Excel from an AI conversation?
- How do I make an HTML report from a query?
- How do I stop my AI making up numbers when analysing data?
- Why does my AI give different answers to the same data question?
- How do I make a line chart of monthly totals with Claude?
- How do I see whether my scheduled report ran?
Analyse data
- How do I get monthly totals from daily data with AI?
- How do I find the top 10 customers by revenue with AI?
- How do I calculate totals by week?
- How do I compare two time periods in one query?
- How do I calculate an average per group?
- How do I find duplicate rows in a large table?
- How do I see which rows changed between two versions of a table?
- How do I find the min and max per group?
Connect your AI
- How do I connect Claude Desktop to a database?
- How do I connect Claude Code to a database?
- How do I connect Cursor to a database?
- How do I add a remote MCP server to Claude Desktop?
- Is there a hosted MCP server for databases?
- Which MCP server lets an AI write to a database?
- How do I use the same data from Python and from my AI?
By industry
- How do I let AI analyse trading positions and risk?
- How do I see what my positions looked like on a past date?
- How do I keep every version of a table so I can audit changes?
Explainers
- What is MCP (Model Context Protocol)?
- What is the difference between an MCP server and an API?
- What is a context window and why does it limit data analysis?
- What is the difference between giving AI a file and giving it a database?
- Is it safe to let AI query my data?
- How do I give an AI read-only access to data?
Problems and fixes
- Claude says the conversation is too long after I paste data. What now?
- My AI only analysed the first few thousand rows. Why?
- My AI invented a column that isn't in my data. How do I stop it?
- ChatGPT's data analysis keeps timing out. What can I do?