Supported Database Dialects

Our platform supports multiple database dialects to meet the diverse requirements of your projects. Here is a list of the currently supported dialects:

mysql MySQL

MySQL is an open-source relational database management system (RDBMS). It uses a client-server model and Structured Query Language (SQL) to interact with the database.

sql_server SQL Server

SQL Server is a relational database management system (RDBMS) developed by Microsoft. It supports a wide range of transaction processing, business intelligence, and analytics applications in corporate IT environments.

postgresql PostgreSQL

PostgreSQL is a powerful, open-source object-relational database system. It uses and extends the SQL language and is known for its proven architecture, reliability, data integrity, robust feature set, extensibility, and the dedication of the open-source community behind the software.

excel Xlsx Structure

Our platform also supports reading data from Excel (Xlsx) file structures. This allows for the importing of tabular data from spreadsheets, which can then be queried as if they were structured databases.

mongo MongoDB

MongoDB is a source-available cross-platform document-oriented database program. Classified as a NoSQL database program, MongoDB uses JSON-like documents with optional schemas. It is known for its flexibility and scalability, making it suitable for a wide range of applications.

Note

When adding a database connection, remember to select the correct database dialect from the “Database Dialect” combobox.