Query databases with natural language. Enrich data with AI. Keep your data private and local. Mayo is your autonomous research & data analysis partner.
curl -fsSL https://mayo.teleskop.id/install.sh | bash
From natural language queries to AI-powered data enrichment, Mayo gives you a complete data toolkit — all in one terminal.
Ask questions about your data in plain English. Mayo's AI generates optimized SQL, executes it safely, and presents results beautifully — no SQL knowledge required.
Connect to PostgreSQL, MySQL, SQLite, CSV files, and entire folders. Switch between data sources effortlessly.
Batch-process datasets using AI for classification, sentiment analysis, data cleaning, and custom enrichment tasks.
Index PDF, Markdown, and text documents into a semantic vector store. Cross-reference knowledge with your SQL data.
AI-powered data reconciliation between different sources. Automatically identify mapping patterns and discrepancies.
Expose Mayo as an API with mayo serve. Multi-session support, Bearer auth, CORS — ready for
integration.
Persistent sessions that save your queries, results, and history. Export polished reports with one command.
Link your databases, CSV files, or entire folders. Mayo auto-discovers schemas and metadata.
/connect postgres postgres://user:pass@host/db
Type your question in natural language. Mayo's AI understands context, generates SQL, and lets you review before execution.
"What are our top 10 customers by revenue this quarter?"
Get instant results with optional AI-powered analysis. Enrich, reconcile, and cross-reference across sources.
/enhance start --prompt "Classify sentiment"
Export beautiful markdown reports, share via API, or save results for later research sessions.
/share quarterly_analysis.md
Mayo is designed with a "Security First, Privacy Always" philosophy. Even as a distributed binary, you have 100% control over your data.
Only database schema are sent to the AI. Every single row of your data stays local — analysis and execution happen on your CPU.
Built-in PII detection scans for emails, phones, and credit cards before any cloud communication. Sensitive data is masked.
Use /audit to see the exact JSON payload sent to the AI at any time. Trust, but verify your
data traffic.
Review every SQL query before it runs. Edit on the fly, cancel, or approve — you're always in complete control.
API keys stored in your OS Keychain (macOS / Windows). Keys are encrypted and never stored in plain text files.
Mayo only communicates with your database and chosen AI provider. Verify with standard network monitoring tools.
Install Mayo via the install script, go install, or by building from source. Then run
mayo to start the interactive shell and use /wizard for guided setup — it walks
you through configuring your AI provider and connecting your first data source.
Mayo handles natural language database queries, data reconciliation, AI-powered data enrichment (sentiment analysis, classification, cleaning), document indexing (RAG), cross-source JOINs (e.g., Postgres + CSV), and polished report generation.
Absolutely. Mayo operates with a "Zero-Rows Cloud" policy — only schema metadata leaves your machine. PII is automatically masked, credentials are stored in your OS keychain, and you can audit every payload sent to the AI. Your actual data rows never leave your local environment.
Mayo supports OpenAI (GPT-4, etc.), Google Gemini, Anthropic Claude, and Groq. You can switch providers
and models at any time during a session using the /model command.
Mayo supports PostgreSQL, MySQL, SQLite databases, as well as CSV files and entire folders. You can connect multiple sources simultaneously and even perform cross-source JOINs via the in-memory engine.
Yes! Run mayo serve --port 8080 to start a secured REST API server with multi-session
support, Bearer token authentication, and CORS. Integrate Mayo's capabilities into any application.
Mayo requires macOS, Linux, or Windows with SQLite3 installed and an API key for at least one supported AI provider (OpenAI, Gemini, Anthropic, or Groq). If building from source, Go 1.21+ is required.
Get started with Mayo in under 30 seconds.
curl -fsSL https://mayo.teleskop.id/install.sh | bash