What It Reads
What ZenSearch indexes from MySQL.
Schema Discovery
ZenSearch introspects your MySQL schema — tables, columns, indexes, foreign keys, and views — to understand the data model and generate accurate queries.
Natural Language to SQL
Translate questions into MySQL-compatible SQL. ZenSearch handles MySQL-specific syntax, functions, and data types for correct query generation.
TLS Encryption
Connect over TLS with support for custom CA certificates. Secure connections for cloud-hosted MySQL instances and on-premise databases.
Table & View Filtering
Select which tables and views to expose for querying. Exclude sensitive tables or limit the scope to specific schemas for focused results.
Charset Configuration
Configure character set and collation for proper handling of multilingual data. UTF-8, latin1, and other MySQL character sets are supported.
Read-Only Execution
Generated queries are validated to ensure read-only execution. Mutation statements are blocked before they reach the database.
Setup
Up and running in three steps.
01
Connect
Authenticate your account and select the resources to index. ZenSearch handles OAuth, API keys, and enterprise SSO.
02
Index
ZenSearch parses, chunks, and vectorizes your content. Incremental sync keeps everything up to date automatically.
03
Delegate
Your coworker searches, answers, and acts across this source — with permission-aware results and governed actions.
In Practice
Questions your team can finally ask.
Once MySQL is connected, your team asks in natural language and gets cited answers — and governed action — instantly.
"What is the top-selling product category this month?"
Generates an aggregation query across orders and products tables with date filtering and returns the category with the highest revenue.
"How many active subscriptions are about to expire in the next 7 days?"
Queries the subscriptions table for active records with expiry dates within the next week and returns the count with a breakdown by plan type.
"Which users have not logged in for over 90 days?"
Filters the users table by last login date and returns a list of inactive users with their registration dates and last activity timestamps.
Related Integrations
Get Started
Put MySQL
to work.
Connect MySQL in minutes and let your coworker read, answer, and act on it.
Try it