- Home
- AI Database Assistants
- Tablix
Tablix
What it is
Tablix is an open-source, self-hosted .NET server and React dashboard for natural-language database questions. It connects to SQLite, PostgreSQL, MySQL, and SQL Server, returning executed SQL, rows, row counts, and evidence with each answer. The system scans tables, keys, indexes, and relationships, then creates editable database and table context. Workflows are available in the dashboard, through an MCP endpoint for agents, and through REST for applications and automation. Configurable model providers include Ollama, OpenAI, OpenAI-compatible endpoints, and Gemini; database chat and MCP require tool-calling support. Statement types can be permitted per connection, calls are scoped to the selected database, and multi-statement SQL is rejected. The dashboard includes setup, schema browsing, context editing, query execution, chat, and CSV or JSON export. Docker Compose starts the server, dashboard, MCP endpoint, product state, and a sample SQLite database. Tablix says it has no cloud dependency or telemetry; outbound calls go to the configured provider, or none with local Ollama. The project is described as early software. For version 0.3.0, database passwords and provider keys are stored in cleartext in tablix.db.
For and against
For
- Answers include SQL, rows, counts, and evidence
- Supports four listed database systems
- Dashboard, MCP, and REST access
- No cloud dependency or telemetry stated
- CSV and JSON exports
Against
- Described as early software
- Database chat and MCP need tool-calling support
- Version 0.3.0 stores secrets in cleartext
- Requires self-hosted deployment
The verdict
Tablix connects natural-language questions with executed database queries and inspectable evidence across several access methods. Its self-hosted design and MIT license suit internal use, while the documented cleartext secret storage requires protection of tablix.db.
Who it suits
Tablix suits data, platform, AI, DevOps, SRE, and coding-agent teams needing self-hosted natural-language database access.
On the record
- Access methods
- Tablix provides a dashboard, an MCP endpoint for agents, and a REST API for applications and automation.tablix.ai · read 7 Oct 2026
- Agent clients
- The site names Claude, Codex, Cursor, and Gemini as MCP clients that can connect to Tablix.tablix.ai · read 7 Oct 2026
- Dashboard
- The built-in dashboard includes setup, schema browsing, context editing, query running, chat, and CSV/JSON exports.tablix.ai · read 7 Oct 2026
- Database support
- The same server and dashboard can connect to SQLite, PostgreSQL, MySQL, and SQL Server.tablix.ai · read 7 Oct 2026
- Data handling
- Tablix says it is self-hosted and has no cloud dependency or telemetry; outbound calls go only to the configured model provider, and local Ollama requires none.tablix.ai · read 7 Oct 2026
- Deployment
- Docker Compose starts the server, dashboard, MCP endpoint, product state, and a sample SQLite database.tablix.ai · read 7 Oct 2026
- Intended users
- The site identifies coding agents, data and platform teams, AI engineers, DevOps and SRE teams, and teams onboarding legacy schemas as use cases.tablix.ai · read 7 Oct 2026
- Interfaces
- Tablix exposes workflows through its dashboard, MCP for agents, and REST for applications and automation.tablix.ai · read 7 Oct 2026
- License
- The site describes Tablix as MIT licensed.tablix.ai · read 7 Oct 2026
- Maturity
- The site describes Tablix as early software and says it fits internal tools, development environments, and read-only production access with proper database permissions.tablix.ai · read 7 Oct 2026
- Model integrations
- It can be configured to use Ollama, OpenAI, OpenAI-compatible endpoints, or Gemini; database chat and MCP workflows require tool-calling support.tablix.ai · read 7 Oct 2026
- Model providers
- It can configure Ollama, OpenAI, OpenAI-compatible endpoints, and Gemini; database chat and MCP require tool-calling support.tablix.ai · read 7 Oct 2026
- Privacy
- Tablix is self-hosted and states that it has no cloud dependency or telemetry; outbound calls go to the configured model provider, or none when using local Ollama.tablix.ai · read 7 Oct 2026
- Product
- Tablix is a self-hosted .NET server and React dashboard for asking natural-language questions of databases.tablix.ai · read 7 Oct 2026
- Query controls
- Statement types can be allowed per database, calls are scoped to the selected connection, and multi-statement SQL is rejected.tablix.ai · read 7 Oct 2026
- Schema context
- It crawls database tables, keys, indexes, and relationships, then generates editable database and table context.tablix.ai · read 7 Oct 2026
- Security limitation
- The project README says database passwords and provider API keys are stored in cleartext in tablix.db for v0.3.0 and recommends protecting that file with OS-level permissions.github.com · read 7 Oct 2026
- Verified answers
- Database chat returns answers backed by executed queries, with SQL, returned rows, row counts, and evidence.tablix.ai · read 7 Oct 2026
