SQL Query Notebooks and Editors

Redash is a self-hosted analytics platform and SQL data visualization tool. It provides a web-based SQL query editor for writing, executing, and scheduling database queries, and functions as a business intelligence dashboard for monitoring metrics via visual widgets. The platform distinguishes itself through its data source connectors, which integrate with various SQL, NoSQL, and API-based stores to retrieve information for analysis. It enables self-service analytics by allowing users to run queries with dynamic parameters and supports shared data reporting via public links or embedded dashboards. The system covers a broad range of capabilities, including a data visualization engine for creating charts and maps, automated data alerting for monitoring query thresholds, and role-based access control for managing user permissions. It also includes utilities for database schema browsing and exporting query results. Administration is supported through a command-line interface for system tasks and database schema initialization.

DbGate is a universal database management tool and SQL client that provides a unified interface for querying and administering multiple SQL and NoSQL databases. It functions as a multi-database administration GUI and SQL IDE, allowing users to write and execute scripts and manage database schemas. The project distinguishes itself by acting as an API client and explorer for REST, GraphQL, and OData services, enabling users to fetch and export data from these endpoints. It also serves as a data integration tool, facilitating the movement of records between diverse databases and file formats such as CSV, JSON, XML, and Excel. The platform covers broad capability areas including data visualization through ER diagrams and geospatial mapping, schema administration with structure comparison and model deployment, and secure connectivity via SSH tunneling and identity provider integration. It also supports automation through the generation of data migration and database operation scripts. The application is designed for multi-platform deployment, running as a native desktop application, a web-based service, or within Docker containers.

This project is a business intelligence suite and SQL data visualization platform used for data analysis, reporting, and monitoring. It provides a web application for exploring datasets and building interactive dashboards, complemented by a web-based SQL query editor for analyzing raw data from connected stores. The platform features a semantic data layer to define standardized metrics and dimensions, ensuring consistent data interpretation across reports. It includes a security framework with role-based access control to manage user permissions and authentication across shared dashboards. The system covers a range of capabilities including no-code data visualization for creating charts and geospatial maps, interactive dataset analysis, and SQL database integration. It also supports programmatic platform management and query automation through a REST API.

MPAndroidChart is an Android charting library and data visualization framework that provides a set of reusable view components for rendering statistical data. It enables the display of numerical datasets through various chart types, including line, bar, pie, radar, bubble, and candlestick charts. The library focuses on an interactive graphing workflow, allowing users to explore complex data sets through scaling, panning, and animations. It includes specific support for financial charting to track market trends and price movements, as well as tools for building mobile dashboards.

c3 is a charting library for creating reusable data visualizations and interactive charts based on the D3 JavaScript framework. It functions as a declarative visualization framework that generates complex charts through high-level configurations rather than manual SVG manipulation. The project provides a reusable chart component library and a tool for converting raw datasets into scalable vector graphics. These capabilities allow for the implementation of interactive data visualizations and web-based data reporting using standardized templates. The library supports the development of custom dashboards and the transformation of datasets into interactive graphs. It uses a rendering engine to map data arrays to visual properties and ensure consistent layouts across different screen sizes.

SQL Chat is a Docker-deployed chat interface that translates natural language questions into SQL queries and executes them against connected databases. It uses a large language model to generate SQL from plain English instructions, supporting both querying and record modification through INSERT, UPDATE, and DELETE statements within the chat conversation flow. The application connects to MySQL, PostgreSQL, MSSQL, TiDB Cloud, and OceanBase databases through a unified driver abstraction layer, allowing users to interact with multiple database types from a single chat interface. Users provide their own OpenAI API key for authentication, or can configure a custom API endpoint to use self-hosted or third-party AI models like Ollama. An optional database-backed account system tracks per-user usage, enforces spending limits, and processes payments. The project is packaged as a Docker container with environment variable configuration for authentication and AI service settings, enabling straightforward self-hosted deployment.

Hellocharts-android is a data visualization library and charting framework for Android applications. It provides a collection of custom view components used to render datasets as visual elements, such as line, column, and pie charts. The library supports interactive visualizations that allow users to navigate data through touch gestures, including pinching, scrolling, and panning. It also includes built-in capabilities for animating data points and chart elements to create smooth visual transitions during dataset updates. The framework covers a broad range of visualization needs, including chart generation, axis configuration for scales and labels, and the rendering of graphical plots for application analytics and reporting.

nvd3 is a data visualization framework and reusable web graphing library. It provides a collection of interactive charting components built on top of the D3.js library to render complex datasets as graphics within a web browser. The library functions as a wrapper for D3.js, offering predefined chart types and modular templates. This implementation allows for the creation of custom data graphs and web dashboards without requiring the author to write low-level SVG code from scratch. The system utilizes SVG-based vector rendering and attribute-driven styling to generate visualizations. It incorporates data binding and event-driven interactivity to support dynamic data exploration.

Rainfrog is a terminal-based database client that connects to multiple database engines, combining schema browsing, interactive SQL query execution, and inline data editing into a single terminal interface. It provides a tree navigator for exploring tables, columns, and indexes, and an inline cell editor that automatically constructs and executes the necessary UPDATE statements when a cell value is changed. The application also supports modal Vim-style keyboard shortcuts for cursor movement and editing, making it usable entirely from the keyboard. Query results are fetched in chunks and paginated on demand, allowing smooth scrolling through large datasets without overwhelming the terminal. System metadata is cached at connection time to speed up schema tree navigation, and the user interface is built on a retained-mode widget tree that renders via a framebuffer with mouse and keyboard event handling. Keybindings, display settings, and mouse capture behavior are all configurable through a YAML file loaded at startup. Connections can be configured using connection strings or individual parameters such as host, port, and credentials. The client supports saving frequently used SQL queries as named favorites for quick replay and can export query results or entire tables to CSV files saved to the system downloads directory.

Illa-builder is a low-code internal tool builder and API integration platform used to create business applications and admin panels. It functions as a database GUI dashboard and visual workflow automator, allowing users to connect to databases and external APIs to manage data and automate business processes. The platform provides a self-hosted app framework that can be deployed on private infrastructure via Docker. It enables the creation of custom dashboards and CRMs while maintaining full control over data and hosting. The system includes a visual drag-and-drop canvas for designing user interfaces with pre-built components. It covers data integration for SQL and NoSQL sources, real-time collaborative editing, and event-driven workflow automation triggered by schedules or webhooks.

Metabase is a business intelligence platform designed to connect to various storage systems and relational databases for data exploration, visualization, and reporting. It provides a centralized environment where users can build queries through a graphical interface or raw code, transforming raw information into interactive dashboards and charts. The platform is built to support self-service analytics, allowing non-technical team members to extract insights without requiring deep knowledge of database syntax. The platform distinguishes itself through a metadata-driven modeling layer that abstracts complex database schemas into user-friendly business entities. It includes an automated workflow engine that enables users to trigger external processes and update records directly from the interface, bridging the gap between data analysis and operational action. For organizations requiring external distribution, the software provides an embedded analytics solution that allows secure integration of dashboards into third-party websites and applications, supported by sandboxing to isolate visual components. Beyond core visualization, the system incorporates artificial intelligence to assist with query generation and data summarization through natural language interactions. It maintains strict data governance through granular role-based access control, ensuring that permissions are managed consistently across all connected information assets. The platform handles the full lifecycle of data retrieval, including orchestration, caching, and translation of high-level inputs into database-specific syntax.