Welcome to Metriql Documentation
Learn how to transform natural language into powerful SQL queries and actionable insights.
What is Metriql?
Metriql is an AI-powered analytics platform that allows you to query your databases using plain English. No SQL knowledge required—just ask your questions naturally and get instant results with beautiful visualizations.
Quick Start
Create an Account
Sign up for a free account at Metriql. No credit card required for the trial period.
Connect Your Database
Connect your PostgreSQL, MySQL, MongoDB, or other supported databases. We support both cloud and self-hosted databases.
Start Querying
Type your questions in plain English and get instant SQL queries with results.
Installation
Web Application
The easiest way to use Metriql is through our web application. No installation required!
Access Web AppCLI Tool
API Access
Integrate Metriql into your applications using our REST API or official SDKs.
npm install @metriql/sdk
pip install metriql-sdk
How It Works
Metriql uses advanced AI models to understand your natural language queries and convert them into optimized SQL queries.
1. Natural Language Input
You type your question in plain English, just like you would ask a colleague.
2. AI Processing
Our AI analyzes your query, understands the intent, and generates optimized SQL.
3. Results & Visualization
Get instant results with automatic chart generation and insights.
Natural Language Processing
Metriql's NLP engine understands various ways of asking questions. Here are some examples:
SQL Generation
Every natural language query is converted to SQL. You can always view and edit the generated SQL.
Connecting Databases
Metriql supports connecting to multiple databases simultaneously. Follow these steps:
- 1Navigate to Data SourcesGo to Settings → Data Sources in your dashboard
- 2Choose Your Database TypeSelect from PostgreSQL, MySQL, MongoDB, and more
- 3Enter Connection DetailsProvide host, port, database name, and credentials
- 4Test & SaveTest the connection before saving
Security Note
All connection credentials are encrypted at rest and in transit. We use industry-standard security practices to protect your data.
Supported Databases
PostgreSQL
Full support for PostgreSQL 10+ including advanced features like JSONB and CTEs.
MySQL
Support for MySQL 5.7+ and MariaDB with all standard SQL features.
MongoDB
Query MongoDB collections using natural language, automatically converted to aggregation pipelines.
Snowflake
Connect to your Snowflake data warehouse for large-scale analytics.
BigQuery
Google BigQuery integration for petabyte-scale data analysis.
Redshift
Amazon Redshift support for cloud data warehousing.
Writing Natural Queries
The key to getting great results is writing clear, specific queries. Here are some tips:
Be Specific
Use Natural Time References
Include Sorting and Limits
Query Examples
Need Help?
Can't find what you're looking for? Our team is here to help!