Last updated: 4 July 2026

MySQL / MSSQL

MySQL / MSSQL

Live
Auth: DB credentials · Plans: Business, Enterprise · Tools: 5 · Category: Database

Query MySQL and SQL Server databases in plain English with read-only, rate-limited access.

Who needs this: Businesses running ERP systems, e-commerce platforms, or custom applications on MySQL or Microsoft SQL Server.

Example questions once connected

  • How many active customers do we have?
  • Show me unpaid invoices older than 30 days
  • Which branch has the highest sales this quarter?
  • List all products with stock below 20 units
⚠️

Create a dedicated read-only user. Do NOT connect with your admin account. Ask your developer to run: CREATE USER 'msharti_read'@'%' IDENTIFIED BY 'your-secure-password'; GRANT SELECT ON your_database.* TO 'msharti_read'@'%';

Step-by-step setup

  1. Gather connection details. Ask your developer for: Host, Port (3306 for MySQL, 1433 for MSSQL), Database name, Username, Password.
  2. Connect in Msharti. Go to Connectors → MySQL / MSSQL → Set Up. Fill in all fields. Toggle SSL if required. Click Test Connection.
  3. Confirm success. Msharti runs SELECT 1. "Connected — 3 tools active" means you are done.

Tool reference

These are the tools the AI can call on this connector. Each tool fires automatically when you ask a relevant question.

run_query() Execute a read-only SELECT query on the MySQL or MSSQL database.
Inputs natural language question (AI generates the SQL)
Try asking "Which sales rep closed the most deals in April?"
Returns Jane Mwangi — 14 deals, KES 3.4M total. Next: David Ochieng — 11 deals, KES 2.1M.
describe_schema() Return column definitions, types, and key constraints for a table.
Inputs table_name
Try asking "Describe the invoices table"
Returns invoice_id (int PK), customer_id (FK), invoice_date (date), due_date (date), amount (decimal), paid (bit), branch_id (int FK)
list_databases() List available databases on the connected server.
Inputs none
Try asking "What databases are available on this server?"
Returns erp_production, erp_archive_2024, crm_data, reporting

Limits

  • Same read-only enforcement as PostgreSQL — INSERT, UPDATE, DELETE blocked at the gateway.
  • 500-row result cap per query. 30-second timeout.
  • For MSSQL, Windows Authentication is not supported — use SQL Server Authentication with a dedicated read-only login.

Troubleshooting

ProblemCauseFix
Connection refused Wrong host/port, or firewall blocking Verify host and port. Ask IT to whitelist Msharti's IP.
Authentication failed Wrong credentials Verify username and password. Check the user has remote access enabled.
SSL required Database enforces SSL Toggle SSL on in the Msharti form.

Related connectors

PG
PostgreSQL
Query your PostgreSQL database in plain English — the AI writes the SQL, you get the answer.
 SF
Salesforce
Query opportunities, accounts, pipeline summaries, and activities in Salesforce CRM.
 SG
Sage
Query invoices, account balances, journal entries, and aged debtor reports from Sage Accounting.
Need help? [email protected] — Nairobi-based, same time zone.