Open-Source Text-to-SQL and Data Chat Tools

LocalSheets is a spreadsheet for people who want their workbooks on their own disk, with optional AI through a local Ollama instance. It runs from a single HTML file in a desktop browser and works offline without an account or cloud service. The app doesn't collect analytics or tracking data.

NocoBase is a self-hosted platform for teams building business applications for themselves or clients, including CRM, help desks, and project management systems. It combines a visual no-code editor with support for AI coding agents, so business users can adjust what agents build without editing code. Business data stays in your own database.

SQL Chat is a SQL client for people who want to work with databases using natural language. Its chat interface lets you ask for data and request database changes without writing every SQL statement yourself.

Prismos AI is a desktop assistant for people working with private documents and technical files. It uses local Ollama models to answer questions and retain knowledge for later conversations.

Desktop Commander lets AI assistants work with files and programs on your computer or a server you own. It's for developers, people handling documents, and server owners who want their assistant to act on a machine and read the results directly.

PandasAI is a Python library that executes data analysis code in your environment and lets analysts ask questions in plain language. It can isolate that execution in Docker. Its documented LiteLLM integration uses OpenAI's gpt-4.1-mini, so model requests go to a cloud service and require an API key.

Wren AI is a self-hosted context and query engine for developers and data teams building AI analytics. It queries your databases using business definitions you control. Model execution depends on the connected agent: using Claude Code’s standard cloud connection sends prompts and model responses to its remote provider, even when Wren's engine runs on your servers.

Grist is a relational spreadsheet for teams building shared data tools beyond a flat grid. Linked tables, typed columns and custom layouts let users organize records into applications for their own workflows.

Marginalia is a research agent for people whose papers, notes and working files are spread across a mixed document library. It reads relevant parts of the original files before writing answers with citations.

Chat2DB Community is a free local database client for developers, database administrators and analysts who want AI assistance beside their SQL editor. It runs on Windows, macOS and Linux, or in Docker with browser access. You connect your own AI model; where AI requests go depends on that connection, so the local app alone doesn't guarantee local inference.

Kady is an AI research assistant for scientists who want to turn plain-language requests into analyses, literature reviews and research outputs. It works in a desktop workspace where you can inspect its code and files, redirect ongoing work or stop a run.

Neo4j LLM Graph Builder converts documents and web content into knowledge graphs for people building searchable collections or AI applications with Neo4j. It uses an LLM to identify entities, relationships, and their properties.

GenOffice is a Microsoft Office alternative for people who want to edit documents on their own computer and let an AI agent make changes inside the files. It works with native .docx, .xlsx and .pptx files alongside PDF, Markdown and HTML.

qabot lets you ask questions about files and databases in plain language from your terminal. It pairs a local DuckDB database with an AI model that writes and executes SQL, making it useful for analysts and developers who want to explore data without writing every query themselves.

DB-GPT is a self-hosted AI data assistant for teams analyzing business data and developers building data applications. It connects plain-language questions to database queries and code-based analysis.

Excel AI Assistant is an MIT-licensed add-in for people who want AI to make changes directly in their spreadsheets. It runs on your machine alongside Excel for Mac, Windows or the web, and uses plain-language requests to edit the open workbook.

Kangaroo is a desktop SQL client and database administration tool for developers and database administrators. It brings querying, data editing and schema work into one application, with an AI assistant available in the database workspace.

ktx gives analytics agents shared metric definitions and business context before they answer questions or write SQL. It's for teams that need agents to reuse approved calculations rather than invent their own each time.

SnowChat is a self-hosted text-to-SQL app for people who want to ask questions about their Snowflake data in plain language. It generates SQL and returns results through a Streamlit chat interface, so analysts and business users can explore data without writing every query themselves. A hosted demo is also available.

MCP Toolbox for Databases connects coding assistants and AI agents to databases. It's for developers who want assistants to inspect data during development or use defined database actions in applications.

Robby chatbot is an open source web app for people who want to ask questions about their documents, analyze tables in plain language, or summarize YouTube videos. You can run the Streamlit app on your own machine on macOS, Linux or Windows. A hosted Streamlit app is also available.

BambooAI is a self-hosted AI data analyst for people working with tabular datasets who want to inspect the calculations behind an answer. It turns plain-language questions into Python analysis and charts, then reruns the calculations cited in its report against the original data to check that the numbers reproduce.

Data Formulator is a local AI data analysis workspace for analysts who want to explore questions through charts and keep track of alternative investigations. This Microsoft Research project combines natural language requests with direct chart editing. You can revisit an earlier result and branch into a different analysis without losing the original path.

LibreDB Studio is a self-hosted database IDE for developers and database teams who want browser access to data inside their own network. It can run beside the database, with an interface that also works on phones and tablets.

Postgres MCP Pro gives AI assistants access to PostgreSQL databases and tools for investigating performance problems. It's for developers and database maintainers who want an assistant to work with actual schema details and query plans.

Brave Leo is an AI assistant inside the Brave browser for people who want help with what they're reading. Bring Your Own Model support lets you use a local LLM or a remote model for browser conversations.

PrivateGPT is a self-hosted API layer for developers building applications around local models. It requires a separate inference server, such as Ollama, llama.cpp, vLLM or LocalAI; it doesn't run models itself.

PenEcho is a visual workspace for people working through ideas with handwritten notes, equations and sketches. AI uses the canvas as context and places answers or interactive results beside your work.

Capka is a self-hosted AI agent for people and teams whose work ends in a document, spreadsheet or code patch. It works with uploaded files, runs code and returns editable outputs you can revise through conversation. The app and its Linux sandboxes run on your own server.

Kition is a desktop AI workspace for writing, research, and project planning. Its agent works directly with editable project files, so you can inspect proposed changes in the documents and boards they affect.

Vanna is a Python framework for adding database chat to analytics applications and internal tools. The project is archived and no longer maintained.

TaskWeaver is an AI agent framework for developers building assistants that analyze data through Python code. The project is archived and no longer maintained.