Built-In Agent (local, schema-indexed)
Knowledge-base-first discovery, few-shot shortcuts, live column hydration with pruning, multi-attempt validation (including result-set metadata), and thumbs-up examples saved to your local knowledge base.
The Desktop Powerhouse
Intelligent SQL Assistance, Deep Analysis, and Visual SQL Across DBMS Platforms
Octofy Pro leads with intelligent SQL assistance: turn natural language into SQL for the connection you have open, improve the script already in your editor, or narrow in on runtime errors—with optional context from conversation history, pinned objects, and verified value mappings. Use the Built-In Agent for a local, schema-indexed pipeline (knowledge-base-first discovery, vector indexes, validation loops, and thumbs-up examples saved on your machine), or wire in the Octofy Agent enterprise API for hosted discovery, streaming SQL generation, schema administration, and remote few-shots. It runs against the relational engines you already use (for example SQL Server, PostgreSQL, and MySQL, plus others through ODBC). When you need to interpret results, load from a table or view, an arbitrary SELECT, or the preview pane; Octofy classifies columns and drives nine analysis modes—counts and sums by category with date grouping (month, quarter, year, ISO week), configurable percentiles, distribution pivots for counts and sums (including row-percent views), and scatter bubbles sized by count or sum—shown as bar, stacked, time-series, and bubble charts, with filters, sortable summary pivots, drill-down to raw rows, chart copy, quick charts, and column value frequency. Prefer a canvas? A visual query designer still lets you compose joins and inspect generated SQL next to the editor.
Feature Carousel
Intelligent SQL assistance
Natural language to SQL, script optimization, and error-aware fixes with local schema indexes or the Octofy Agent API.
Visual query designer preview
When you compose joins on the canvas, choices map to SQL like this—pick a join type to preview.
Only matched records
SELECT c.CompanyName, o.OrderDate
FROM Customers c
INNER JOIN Orders o ON c.CustomerID = o.CustomerID
WHERE o.OrderDate >= DATEADD(day, -30, GETDATE());Core Features
Local analysis, schema-only SQL
Work against your databases on your own machine without shipping row data to a cloud LLM or public endpoints. The built-in agent generates SQL from schema metadata only—table and column names, types, and relationships—keeping sensitive cell values local.
Octofy Agent (enterprise API)
Optional remote agent with discovery, SSE SQL generation, schema sync administration, and hosted few-shot storage when your organization runs the API.
Interactive analysis & visualization
Start from the object tree (Analyze), query results, or preview Chart—same engine whether you load a full table or a limited row set. Variable roles (category, distribution, sum) respect column typing and cardinality limits; the filter panel lets you include or exclude values and date ranges, then reapplies every aggregation on the filtered subset. Summary grids pair with a raw-data grid for drill-down, exclude-blanks, clipboard copy, and preview export to CSV or Excel.
Visual query designer
Compose joins on a canvas, adjust relationships visually, and review the generated SQL alongside the text editor when you want a graphical starting point.
Release Notes
v8.2.0 - 2026-03-28
- Introduced the built-in AI agent: schema-grounded natural-language SQL assistance, iterative refinement, and diagnostic support integrated directly into the Octofy Pro desktop experience.