SQL and assistant¶
Querying with DuckDB SQL, and asking a language model about your data in plain words.
Each row is one job, with where to find it in the app, on the command line and as an MCP tool for AI agents. A dash means that surface does not offer it.
| I want to... | In the app | Command line | MCP tool |
|---|---|---|---|
| Query open files with SQL | SQL Panel | --sql |
run_sql |
| See how a query would run | Explain a query | --explain |
run_sql |
| Ask the assistant about your data | Chat Assistant | - | - |
| Set up a model, an API key or Ollama | Assistant Setup | - | - |
| What the assistant sees and sends | How the Assistant Understands Your Data | - | - |
To let an assistant outside Octa (Claude Desktop, Claude Code, any MCP client) work on your files, see the MCP server.