EZQL
Outerbase is a comprehensive database interface that enables users to easily explore and collaborate on data without writing any SQL. It fe...
Last verified:
What is EZQL?
Outerbase is an AI-powered database interface that allows users to view, edit, query, and visualize data from various SQL and NoSQL databases like Postgres, MySQL, SQLite, MongoDB, and more. It features EZQL, an AI agent that converts natural language questions into SQL queries, enabling instant insights without SQL expertise. The platform offers spreadsheet-like table editors, customizable plugins, dashboards, relational diagrams, and data cataloging for better data management and collaboration.
Key features include AI-powered query generation, automatic chart creation, table plugins for efficiency, embeddable components via the Astra library, and advanced security like two-factor authentication, data encryption, SSH tunneling, and HIPAA/SOC 2 compliance. Users can define business terms, create virtual relationships, and build self-serve analytics dashboards. EZQL understands database schema, foreign keys, and indexes to handle complex joins and conversations.
It's designed for developers, data analysts, startups, teams, and non-technical users who need an intuitive, collaborative tool to manage databases. Outerbase supports bringing your own database, private AI models that don't train on your data, and enterprise features for secure, scalable data experiences.
EZQL pricing
Pricing model: Freemium
Pricing details are not explicitly listed on the website; features suggest a free tier or trial for basic use with AI Copilot, table editor, and connections. Paid plans likely include Pro for advanced collaboration and Enterprise for HIPAA/SOC 2 compliance, private deployments, custom models, and global support. Contact sales for specific plans and inclusions.
EZQL pros
- AI EZQL converts natural language to SQL
- Supports Postgres, MySQL, SQLite, MongoDB
- Spreadsheet-like responsive table editor
- Customizable table plugins marketplace
- Embeddable tables and charts via Astra
- AI-powered query suggestions and fixes
- Automatic chart generation from data
- Self-serve AI-generated dashboards
- Relational diagrams for data visualization
- Data catalog with business terms
- Virtual relationships without schema changes
- Two-factor authentication security
- HIPAA and SOC 2 Type 2 compliant
- Data encryption with AES and RSA
- SSH tunneling for private databases
- Private AI models no data training
- Commands for workflow automation
EZQL cons
- Beta access required for EZQL token
- Limited to supported databases only
- Some AI features like trend analysis coming soon
- Relies on OpenAI models for conversations
- Enterprise pricing not publicly listed
- Plugins depend on marketplace availability
- No direct CSV upload details on main pages
- Potential learning curve for advanced plugins
- AI may need schema understanding tweaks
Frequently asked questions about EZQL
What is EZQL?
EZQL is Outerbase's AI agent that allows users to ask questions about their database in plain English or natural language, converting them to SQL queries. It understands the database schema, tables, foreign keys, and indexes to run complex queries, build charts, and perform cross-table joins without SQL knowledge.
Which databases does Outerbase support?
Outerbase connects to most SQL and NoSQL databases including Postgres, MySQL, SQLite, MongoDB, ClickHouse, Microsoft SQL Server, Snowflake, Google BigQuery, and Amazon Redshift, allowing all data in one place.
Is Outerbase secure?
Yes, it features two-factor authentication, data breach checks, custom access via database roles, HIPAA compliance, SOC 2 Type 2 compliance, data encryption with AES and RSA, SSH tunneling, and private AI models that do not train on user data.
Can I embed Outerbase components?
Yes, as part of the Astra library, Outerbase tables and charts are fully embeddable anywhere, enabling integration into other apps or websites.
What are table plugins?
Table plugins are a constantly expanding network from the marketplace that customize the table editor, making data navigation faster and more efficient for teams.
How does AI help with queries?
AI-powered editor provides suggestions, fixes mistakes in SQL queries, generates queries identifying key insights, and supports conversations via EZQL for instant data analysis.
What is the Data Catalog?
The Data Catalog lets users define business terms for better team and AI understanding, view relational diagrams, and create virtual relationships between columns without altering the schema.
Can Outerbase generate dashboards?
Yes, users can build dashboards from scratch or have AI generate them, including AI-generated charts directly from conversations, with embeddable analytics.
Is EZQL open-source?
Yes, EZQL is open-source, allowing it to be embedded in other apps to query databases using natural language anywhere.
What enterprise features are available?
Enterprise features include deploying custom models in your cloud, HIPAA and SOC 2 Type 2 standards, metadata tagging, expert setup assistance, and 24/7 global team support.