Connect MySQL to ZenSearch
Ask your MySQL databases questions in plain English. Schema discovery and NL-to-SQL let your team get answers without writing queries.
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.
Up and running in three steps
Authenticate your account and select the resources to index. ZenSearch handles OAuth, API keys, and enterprise SSO.
ZenSearch parses, chunks, and vectorizes your content. Incremental sync keeps everything up to date automatically.
Your team searches across all connected sources with AI-powered semantic search, chat, and agents.
Questions your team can finally answer
Once MySQL is connected, your team can ask natural-language questions and get cited answers 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.
PostgreSQL
ClickHouse
MS SQL Server