Skip to content
SPECIFICTION
Get listed

Insight O' Mate

insightomate.lunamic.co

From $6.01/mo Free plan Open source WindowsmacOSLinux
Visit insightomate.lunamic.co
Spec score 8.9 #3 of 21 in AI Database Assistants

What it is

Insight O' Mate is a desktop tool that translates plain-English questions into database queries and runs them locally against databases and spreadsheets. It supports MongoDB, Firebase Firestore, Redis, Amazon DynamoDB, Excel, and CSV; the maker says Cassandra, Elasticsearch, Neo4j, and Couchbase are planned. For spreadsheets, it can filter, group, aggregate, and join data across sheets. It is designed for read operations and does not generate write, update, or delete operations, and it provides result visualizations. The hosted language engine receives prompts and collection or field names, while document values, spreadsheet rows, results, connection details, and credentials stay on the user's machine. The engine is described as stateless, does not store prompts, and does not train on user data. Connection strings are kept in the operating system keychain, with an encrypted-file fallback. The app is in public beta and runs on Linux, macOS, and Windows. Its Free plan allows 20 database analyses per day for one founder and one database. Pro costs $29 a month; Ultra costs $79 a month.

Spec sheet

What it does
Insight O' Mate converts plain-English questions into database queries and executes them locally on the user's machine.Read 14 Oct 2026 · insightomate.lunamic.co
Purpose
Insight O' Mate translates plain-English questions into database queries and executes them locally against databases and spreadsheets.Read 2 Oct 2026 · insightomate.lunamic.co
Intended users
The maker identifies software developers and backend engineers, data analysts, business analysts, and privacy-conscious organizations as audiences.Read 2 Oct 2026 · insightomate.lunamic.co
Compliance
The NLP engine acts as a processor under GDPR Article 28, and a Data Processing Agreement is available with Pro and Team plans.Read 2 Oct 2026 · insightomate.lunamic.co
Support
Product, billing, and support inquiries go to [email protected], and the maker says it tries to reply within one business day.Read 2 Oct 2026 · insightomate.lunamic.co
API status
The public POST /api/analyze API is listed as planned for SDK and third-party integrations rather than generally available.Read 14 Oct 2026 · insightomate.lunamic.co
Beta status
The maker says the product is in public beta.Read 2 Oct 2026 · insightomate.lunamic.co
Charts
Results can render as automatically selected charts or tables.Read 14 Oct 2026 · insightomate.lunamic.co
Company activity
LinkedIn lists Lunamic as an IT services and consulting company specializing in cybersecurity and related technology services.Read 14 Oct 2026 · es.linkedin.com
Company founded
Iberinform states that Lunamic Ingeniería y Comunicación SL was incorporated on November 7, 2012.Read 14 Oct 2026 · iberinform.es
Company founder
LinkedIn says Lunamic was founded by Ainoa Celaya Luna.Read 14 Oct 2026 · es.linkedin.com
Company headquarters
Iberinform lists the company's fiscal address in Marbella, Málaga, Spain.Read 14 Oct 2026 · iberinform.es
Company legal name
Iberinform identifies the maker company as Lunamic Ingeniería y Comunicación SL.Read 14 Oct 2026 · iberinform.es
Company size
LinkedIn describes Lunamic as having 2 to 10 employees.Read 14 Oct 2026 · es.linkedin.com
Compliance statement
The maker says the NLP engine acts as a GDPR Article 28 processor and offers a data-processing agreement for Pro and Team plans.Read 14 Oct 2026 · insightomate.lunamic.co
Credential security
Connection strings are stored in the operating system keychain, with an AES-256-GCM encrypted-file fallback, and are not written to disk in plaintext.Read 2 Oct 2026 · insightomate.lunamic.co
Credential storage
Connection strings are stored in macOS Keychain, Windows Credential Vault, or Linux libsecret, with AES-256-GCM encrypted-file fallback.Read 14 Oct 2026 · insightomate.lunamic.co
Dashboards
Users can pin results into draggable, resizable live dashboards.Read 14 Oct 2026 · insightomate.lunamic.co
Data sent
The NLP engine receives the user's prompt and collection or field names, while document values, row data, query results, connection strings, and credentials stay on the user's machine.Read 2 Oct 2026 · insightomate.lunamic.co
Documentation
Documentation covers architecture, getting started, database connections, privacy, and an API reference for the analyze endpoint.Read 14 Oct 2026 · insightomate.lunamic.co
Download platforms
The desktop app is offered for macOS, Windows, and Linux; its download page lists DMG, EXE, AppImage, and Debian package installers.Read 2 Oct 2026 · insightomate.lunamic.co
DynamoDB support
DynamoDB support generates key-value and document access patterns without manually writing expressions.Read 14 Oct 2026 · insightomate.lunamic.co
Firestore support
Firebase Firestore collections and documents can be queried from the desktop application.Read 14 Oct 2026 · insightomate.lunamic.co
Funding or ownership
No funding round, investor, or acquisition information is stated on the company pages or company-directory pages opened.Read 14 Oct 2026 · iberinform.es
Independent classification
Tablif categorizes Insight O' Mate as a live developer product for databases and schemas and says it has no waitlist.Read 14 Oct 2026 · tablif.com
Independent open-source claim
Tablif reports the product as open source and identifies AI as central to its functionality.Read 14 Oct 2026 · tablif.com
Installers
Native installers are offered for macOS DMG, Windows EXE, and Linux AppImage or DEB.Read 14 Oct 2026 · insightomate.lunamic.co
Latest changelog
Beta 3, dated September 4, 2026, added dashboard widgets, in-app bug reporting, support tickets, financial KPI reasoning, and doubled the free quota.Read 14 Oct 2026 · insightomate.lunamic.co
Launch news
The public beta was announced on June 27, 2026.Read 14 Oct 2026 · insightomate.lunamic.co
Limit: browser and mobile access
An independent directory describes the product as a desktop application for Linux, Windows, and macOS, with no listed phone app.Read 14 Oct 2026 · tablif.com
Limit: planned API
The independent directory records an API but the maker's integrations page marks the public API as planned.Read 14 Oct 2026 · insightomate.lunamic.co
Local execution
The desktop client runs generated queries directly against the user's database from their machine.Read 2 Oct 2026 · insightomate.lunamic.co
MongoDB support
MongoDB support covers Atlas, replica sets, standalone deployments, Dockerized MongoDB, find operations, and aggregations.Read 14 Oct 2026 · insightomate.lunamic.co
Natural-language querying
Users can ask questions without writing MongoDB, Firestore, Redis, or DynamoDB syntax.Read 14 Oct 2026 · insightomate.lunamic.co
Planned integrations
Cassandra, Elasticsearch, Neo4j, and Couchbase are listed as planned adapters.Read 14 Oct 2026 · insightomate.lunamic.co
Privacy architecture
Only the prompt and collection or field names are sent to the stateless NLP service; document values, results, credentials, and connection strings stay local.Read 14 Oct 2026 · insightomate.lunamic.co
Product maturity
The maker describes Insight O' Mate as being in public beta, with pre-1.0 beta releases and an API shape that may change.Read 14 Oct 2026 · insightomate.lunamic.co
Prompt templates
Reusable prompts support variable placeholders and one-click reruns.Read 14 Oct 2026 · insightomate.lunamic.co
Query history
The product provides a searchable record of analyses.Read 14 Oct 2026 · insightomate.lunamic.co
Read-only execution
Generated operations are limited to read-oriented actions and exclude database writes and deletes.Read 14 Oct 2026 · insightomate.lunamic.co
Read-only operation
The app is designed for read operations and says it does not generate write, update, or delete operations.Read 2 Oct 2026 · insightomate.lunamic.co
Redis support
Redis support includes keys, hashes, sets, sorted sets, and natural-language command generation.Read 14 Oct 2026 · insightomate.lunamic.co
Retention
The hosted NLP engine is described as stateless and does not store prompts or train on user data.Read 2 Oct 2026 · insightomate.lunamic.co
Retention and training
The hosted NLP engine says it does not retain prompts or results, log inputs, or train on customer data.Read 14 Oct 2026 · insightomate.lunamic.co
Self-hosting status
A self-hosted NLP engine for VPC deployment is planned and is not yet generally available.Read 14 Oct 2026 · insightomate.lunamic.co
Smart fields
The system maps misspelled or alternate field names to the actual schema.Read 14 Oct 2026 · insightomate.lunamic.co
Spreadsheet features
Excel and CSV files can be queried through in-memory filtering, grouping, aggregation, and cross-sheet joins.Read 2 Oct 2026 · insightomate.lunamic.co
Spreadsheet support
Excel XLSX/XLSM and CSV files can be queried locally without credentials or uploading the files.Read 14 Oct 2026 · insightomate.lunamic.co
Supported sources
It supports MongoDB, Firebase Firestore, Redis, Amazon DynamoDB, Excel, and CSV; Cassandra, Elasticsearch, Neo4j, and Couchbase are planned.Read 2 Oct 2026 · insightomate.lunamic.co

Plans and prices

Free Free 20 database analyses per day · one founder · one database Read 2 Oct 2026 · insightomate.lunamic.co
Free Free forever 20 analyses per day · single machine and database · community support · all privacy guarantees Read 14 Oct 2026 · insightomate.lunamic.co
Team $6.01 a month per seat monthly; minimum 2 seats Everything in Pro · 100 analyses per hour per seat · multi-seat workspace · per-seat usage dashboard · role-based API keys · shared prompt library coming soon Read 14 Oct 2026 · insightomate.lunamic.co
Pro $9.01 a month monthly via Dodo Payments 100 analyses per hour · priority NLP queue · real-time dashboard · exports · query history and saved prompts · email support Read 14 Oct 2026 · insightomate.lunamic.co
Ultra $17.01 a month monthly via Dodo Payments Everything in Pro · unlimited usage · custom templates · private dedicated NLP instance · VIP support with 1-hour response Read 14 Oct 2026 · insightomate.lunamic.co
Pro $29 a month Unlimited queries · priority queue · advanced export Read 2 Oct 2026 · insightomate.lunamic.co
Ultra $79 a month Dynamic dashboards · dedicated NLP instance · VIP support Read 2 Oct 2026 · insightomate.lunamic.co

Every Insight O' Mate plan and price →

Strong points and limits

Strong points

  • Runs generated queries locally on the user's machine.
  • Supports six listed database and spreadsheet sources.
  • Spreadsheet tools include cross-sheet joins.
  • Connection strings use the OS keychain or encrypted-file fallback.
  • Available for Linux, macOS, and Windows.

Limits

  • The app is in public beta.
  • Free plan is limited to 20 analyses per day.
  • Free plan covers one founder and one database.
  • Write, update, and delete operations are not generated.

Who it suits

It suits software developers, backend engineers, data and business analysts, and privacy-conscious organizations. Its local query execution and read-only design fit users who need to inspect data without generating write operations.

Insight O' Mate in depth

Read the full write-up

Insight O' Mate is a desktop tool for asking questions of databases and spreadsheets in plain English. It is best suited to developers and analysts who want read-only access without sending data values to a hosted engine. Its local query execution is a strong fit for cautious exploration, but it is in public beta and the free tier is tightly capped.

Overview

The app converts natural-language prompts into queries and runs them on the user’s machine. Current sources are MongoDB, Firebase Firestore, Redis, Amazon DynamoDB, Excel, and CSV; Cassandra, Elasticsearch, Neo4j, and Couchbase are planned rather than supported today. Spreadsheet queries can filter, group, aggregate, and join across sheets, making the app useful beyond database-only workflows.

The privacy boundary is relatively clear: the hosted NLP engine receives the prompt and collection or field names, while document values, spreadsheet rows, query results, connection strings, and credentials remain on the machine. The engine is described as stateless, with no prompt retention or training on user data. Credentials are stored in the operating system keychain, with an AES-256-GCM encrypted-file fallback rather than plaintext files. This is a meaningful safeguard, though prompts and schema names still leave the device.

Read-only operation is a practical safety advantage for exploration, but it rules out using the app to update or delete records. Result visualizations are supported. The product is in public beta, a consideration for organizations weighing adoption.

Key features

Natural-language, read-only querying

Plain-English queries can lower the barrier to investigating data for users who do not want to write queries themselves. Because the app does not generate write, update, or delete operations, it is for reading and analysis rather than data maintenance.

Local execution with a hybrid NLP service

Generated queries execute directly against the user's database from the desktop client. Keeping values, results, and credentials local limits what leaves the machine, while the prompt and field or collection names still go to the hosted NLP engine. That balance may suit teams that want local data access without operating an entirely self-hosted language engine.

Spreadsheet analysis

Excel and CSV support includes filtering, grouping, aggregation, and cross-sheet joins. Those operations make it a broader option for analysts whose work spans files and databases, although the spreadsheet operations run through in-memory processing.

Pricing

The Free plan costs nothing and is limited to one founder, one database, and 20 database analyses per day. It is a reasonable way for a solo user to assess the workflow, but the daily quota and single-database cap make it a poor fit for sustained or multi-source work.

Pro costs $29 a month and includes unlimited queries, a priority queue, and advanced export. It is the relevant step up for users who outgrow the Free limits or need those features. Team is also referenced in connection with the Data Processing Agreement, but no plan price or feature set is provided; treat it as custom pricing.

Ultra costs $79 a month and adds dynamic dashboards, a dedicated NLP instance, and VIP support. It is aimed at users who need those specific capabilities, rather than simply a higher query allowance. No trial or renewal terms are stated.

The NLP engine acts as a processor under GDPR Article 28, and a Data Processing Agreement is available with Pro and Team plans. That can matter to organizations formalizing data-processing terms; the Free plan does not include that agreement.

Platforms

The desktop app runs on macOS, Windows, and Linux, with DMG, EXE, AppImage, and Debian package installers. That cross-platform desktop availability is useful for teams with mixed operating systems, but the product is not described as a web app or self-hosted deployment.

Who it's for

Software developers and backend engineers can use it to inspect supported data sources with natural-language prompts while keeping query execution local. Data and business analysts may value the spreadsheet operations and result visualizations. Privacy-conscious organizations have a concrete boundary to assess: data values and credentials stay on-device, but prompts and schema names are sent to the hosted engine.

It is not the right choice for users who need to change data, need an unsupported source such as Cassandra today, or require a product outside public beta.

Pros and cons

Pro: Queries run locally, while values, results, connection strings, and credentials stay on the user's machine; this reduces the data shared with the hosted engine.

Pro: Excel and CSV support filtering, grouping, aggregation, and cross-sheet joins, extending its use to spreadsheet analysis.

Pro: Read-only query generation avoids generated write, update, and delete operations.

Con: Prompts and collection or field names still go to the hosted NLP engine, so it is not an entirely local language-processing workflow.

Con: The Free plan's one-founder, one-database, 20-analyses-per-day limits restrict broader evaluation and regular use.

Con: Public beta status may make it unsuitable for teams that require a product beyond beta.

Alternatives

Florentine.ai is worth considering if you prefer API or web access and need a free allowance of 500 requests per month across one database and five active collections or tables, with MongoDB and MySQL support.

Outerbase AI may suit teams seeking API, web, self-hosted, or desktop options; its free plan permits up to five users, one base, and 10 EZQL queries per month, with three saved queries and one dashboard.

Snowflake CoCo is another option to compare for a paid product with a free trial and API, desktop, and web platforms.

Wren AI may appeal to individual developers who want a free, open-source context engine used through CLI and MCP without a UI.

BlazeSQL is an alternative for buyers who want a paid AI data analyst with graphs, dashboards, desktop private database connection, and a knowledge base; its Pro plan costs $150 a month.

DataLine is a free, open-source project under GPL-3.0 for readers who prioritize an open-source option.

DataZen is a free desktop option under GPLv3 with no account and a bring-your-own AI provider model.

YourQL is a free desktop application described as a work in progress.

For more options in the category, see AI Database Assistants.

Verdict

Insight O' Mate is a good fit for developers and analysts who want to explore supported databases and spreadsheets from a desktop app, with query execution and sensitive data kept local. The central reason to choose it is that specific privacy boundary combined with read-only safeguards. Look elsewhere if you need write operations, broader source support today, or a product that has moved beyond public beta.

Verdict

Insight O' Mate focuses on local, read-only querying across databases and spreadsheets, with explicit limits on the information sent to its hosted engine. The free plan is restricted to one founder, one database, and 20 analyses per day; Pro costs $29 a month.

Where Specifiction places it

Alternatives to Insight O' MateAll alternatives →