Sequelize
Sequelize is a modern TypeScript and Node.js ORM for Oracle, Postgres, MySQL, MariaDB, SQLite SQL Server, and more. Features solid transaction support, relations, eager and lazy loading, read replication, and more. Define your models with ease and make optional use of automatic database synchronization. Define associations between models and let Sequelize handle the heavy lifting. Mark data as deleted instead of removing it once and for all from the database. Transactions, migrations, strong typing, JSON querying, lifecycle events (hooks), and more. Sequelize is a promise-based Node.js ORM tool for Postgres, MySQL, MariaDB, SQLite, Microsoft SQL Server, Oracle Database, Amazon Redshift, and Snowflake’s Data Cloud. It features solid transaction support, relations, eager and lazy loading, read replication, and more. To connect to the database, you must create a Sequelize instance.
Learn more
QStudio
QStudio is a free, modern SQL editor supporting over 30 databases, including MySQL, PostgreSQL, and DuckDB. It offers features such as server browsing for easy viewing of tables, variables, functions, and configuration settings; SQL syntax highlighting; code completion; the ability to query servers directly from the editor; and built-in charts for data visualization. QStudio runs on Windows, Mac, and Linux, providing particularly good support for kdb+, Parquet, PRQL, and DuckDB. Additional functionalities include data pivoting similar to Excel, exporting data to Excel or CSV, and AI-powered tools like Text2SQL for generating queries from plain English, Explain-My-Query for code walkthroughs, and Explain-My-Error for debugging assistance. Simply send the query you want and select the chart type to draw a chart. Send queries straight from within the editor to any of your servers. All data structures are handled perfectly.
Learn more
Query Streams
Query Streams securely connects Google Sheets and Microsoft Excel to live databases—no VPNs, firewall changes, or coding required. Users can run real-time SQL queries and view results instantly inside spreadsheets. Through a user-friendly add-on interface, even non-technical users can safely adjust parameters and fetch fresh data on demand.
Built for IT teams, analysts, finance departments, developers, students, researchers, and individuals managing personal or academic projects—Query Streams eliminates the need for manual exports or scheduled refreshes. It supports major databases including MySQL, PostgreSQL, SQL Server, MariaDB, SQLite, Access, and more.
With shared queries, secure credential handling, granular access controls, and ultra-fast data compression, Query Streams turns spreadsheets into live dashboards—securely and effortlessly.
Learn more
Peekdata
Consume data from any database, organize it into consistent metrics, and use it with every app. Build your Data and Reporting APIs faster with automated SQL generation, query optimization, access control, consistent metrics definitions, and API design.
It takes only days to wrap any data source with a single reference Data API and simplify access to reporting and analytics data across your teams. Make it easy for data engineers and application developers to access the data from any source in a streamlined manner.
- The single schema-less Data API endpoint
- Review and configure metrics and dimensions in one place via UI
- Data model visualization to make faster decisions
- Data Export management scheduling AP
Ready-to-use Report Builder and JavaScript components for charting libraries (Highcharts, BizCharts, Chart.js, etc.) makes it easy to embed data-rich functionality into your products.
And you will not have to make custom report queries anymore!
Learn more