31 dépôts
Interactive interfaces for writing, formatting, and executing SQL queries with developer aids.
Distinct from SQL Query Builders: Distinct from Query Builders which focus on programmatic construction; this focuses on the interactive manual editor experience.
Explore 31 awesome GitHub repositories matching data & databases · SQL Query Editors. Refine with filters or upvote what's useful.
Chat2DB is an AI-powered SQL client and multi-database GUI manager designed for managing various relational and NoSQL database systems. It serves as a visual database management tool and a natural language to SQL interface, allowing users to convert plain text descriptions into executable and optimized queries. The platform distinguishes itself through automated business intelligence capabilities, which include the generation of real-time data visualization dashboards and AI-driven data analysis from spreadsheets. To ensure data privacy, it supports secure local AI deployment, enabling large
Scans SQL queries for mistakes and applies intelligent, automated corrections to resolve errors.
This project is a collection of educational resources and reference implementations for the Apache Flink stream processing framework. It provides a learning resource focused on mastering distributed stream processing through implementation guides, performance tuning tutorials, and practical examples. The repository features detailed walkthroughs for building real-time data pipelines using the DataStream and Table APIs. It includes specific integration examples for connecting Apache Flink with Kafka brokers and Elasticsearch indices, as well as reference implementations for real-time deduplica
Provides default execution modes and watermarking intervals for stream processing when using the SQL API.
Buf is a toolchain for managing the full lifecycle of Protocol Buffers schemas. It provides a set of tools for schema governance, including linting to enforce style guides, a breaking change detector to ensure backward compatibility, and a system for producing language-specific source code via local or remote plugins. The project distinguishes itself through a remote schema registry that centralizes the hosting, versioning, and distribution of Protocol Buffers modules. This registry allows for server-side enforcement of governance policies, such as blocking updates that introduce backward-inc
Implements a background process that provides real-time autocomplete and navigation for schemas within text editors.
Adminer is a PHP-based database management tool and multi-engine database client. It provides a web-based graphical interface for administering various relational and document database engines. The application is distributed as a single file to simplify installation and deployment on web servers. It supports customization through external stylesheets for visual themes and a plugin architecture to extend core functionality and system behaviors. The tool covers database schema administration, including the creation of views and management of foreign keys. It includes a SQL query editor with au
Ships an interactive SQL editor with automatic completion for table and column names.
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 suc
Provides an interactive SQL editor with formatting and developer aids for writing and executing queries.
Feast is an open-source feature store for machine learning that provides a central platform for defining, storing, and serving features across both training and inference workflows. It operates as a declarative system where feature definitions are written as code in Python files, synchronized to a central registry, and made available for low-latency online retrieval or point-in-time correct historical joins for training datasets. The project abstracts storage behind a pluggable architecture, allowing offline and online backends to be swapped without changing retrieval logic, and coordinates ma
Points a feature retrieval pipeline at a ClickHouse table or view for feature data.
Stack Auth is an open-source authentication and authorization platform that provides pre-built UI components, OAuth integration, team management, and session handling for web applications. It offers a complete authentication lifecycle covering sign-in, sign-up, session management, password recovery, and multi-factor security, with support for passkey authentication and OAuth providers including Google, GitHub, and Apple. The platform includes a team-based permission system with role-based access control, allowing users to be organized into teams with granular permissions for membership manage
Provides a built-in ClickHouse SQL query editor with save and reuse capabilities for analytics tables.
jOOQ is a type-safe SQL query builder for Java that generates code from live database schemas, enabling compile-time validation of SQL syntax and data types. Its core identity is built around a fluent DSL that mirrors SQL structure, a code generator that maps tables, views, and routines to Java objects, and a multi-dialect engine that translates the same DSL into vendor-specific SQL for over 30 databases. The project also includes a SQL parser and transformer for refactoring or dialect conversion, reactive stream integration for non-blocking query execution, and a JDBC proxy diagnostics tool f
Provides a BNF-based interface hierarchy that enables IDE auto-completion for valid SQL clauses and operators.
SQLiteStudio is an open-source graphical tool for browsing, editing, and managing SQLite database files. It combines a full-featured SQL editor with syntax highlighting, a visual database schema designer for creating entity-relationship diagrams, and a plugin-based extensibility platform that allows adding custom functionality through C/C++, JavaScript, Tcl, or Python. The application distinguishes itself through its multi-language scripting engine, which embeds JavaScript, Tcl, and Python interpreters to enable user-defined functions and scripts within SQL queries. It supports encrypted data
Provides a full-featured SQL editor with syntax highlighting, auto-completion, and query history.
Harlequin is a terminal-based SQL IDE that runs queries against DuckDB and SQLite databases, with a plug-in adapter system for connecting to additional database engines. It provides a full-screen text editor with syntax highlighting and fuzzy autocomplete for writing SQL, and displays query results in a scrollable table within the terminal. The application distinguishes itself through a tree-based data catalog that lets you browse database schemas, local files, and remote S3 objects, with the ability to insert or copy paths directly into the query editor. It supports custom key bindings throu
Opens a full-featured interactive SQL editor in the terminal for writing and running queries.
A lightweight client for managing MariaDB, MySQL, SQL Server, PostgreSQL, SQLite, Interbase and Firebird, written in Delphi and Lazarus/FreePascal
Provides a tabbed SQL query editor with syntax highlighting, autocomplete, and editable result grids.
Pinot is a distributed, columnar analytical database designed for high-concurrency, low-latency query processing. It functions as a real-time OLAP datastore, enabling interactive, user-facing analytics by ingesting and querying massive datasets from both streaming and batch sources. The system architecture relies on a centralized controller for cluster coordination and a distributed segment-based storage model to ensure horizontal scalability. The platform distinguishes itself through a hybrid ingestion pipeline that unifies real-time event streams and historical batch data into a single quer
Provides an interactive web-based SQL editor for writing and executing queries against stored tables.
Fleet is an open-source device management platform that provides centralized control over computing devices running macOS, Linux, Windows, Chromebooks, iOS, and Android. It enables organizations to enroll devices, collect real-time telemetry, enforce security compliance policies, and manage software remotely from a single system. The platform can be deployed as a single binary, run locally for testing, or scaled horizontally across cloud infrastructure on AWS, Kubernetes, GCP, or Render, with support for high availability through database replication and load balancing. The platform distingui
Executes stored osquery SQL questions against all hosts to collect specific data and surface security issues.
Studio est un outil de gestion de base de données SQL conteneurisé qui fournit une interface graphique basée sur navigateur pour exécuter des requêtes et gérer des données à travers diverses bases de données SQL. Il consiste en un éditeur de requête spécialisé et une interface d'administration graphique conçue pour l'administration de base de données basée sur le web. Le projet dispose d'un éditeur de requête SQL haute performance avec auto-complétion et astuces de fonction pour exécuter plusieurs commandes de base de données simultanément. Il inclut un éditeur de schéma visuel pour créer et modifier les colonnes de table et un éditeur d'enregistrement qui prépare et prévisualise les changements avant qu'ils ne soient validés (committed) à la source. La plateforme couvre la connectivité aux bases de données et la synchronisation de profils, l'intégration SQL multi-dialecte et un framework d'extension d'interface utilisateur pour ajouter une logique personnalisée aux menus, onglets et barres latérales. Il utilise un wrapper de bureau pour faire le pont avec les pilotes de base de données qui sont autrement restreints dans les environnements de navigateur web standard. L'application est packagée sous forme d'image Docker pour assurer un déploiement cohérent à travers différentes plateformes d'hébergement.
Includes an interactive SQL editor with auto-completion and function hints to accelerate complex query development.
AliSQL is a fork of MySQL by Alibaba that extends the relational database management system with enhancements for high performance, scalability, and enterprise-grade availability. It retains the core MySQL identity as a SQL-based database for storing, organizing, and retrieving structured data, while adding optimizations for large-scale transactional and analytical workloads. The project differentiates itself through a set of Alibaba-specific improvements, including a columnar engine for accelerating analytical queries directly on MySQL tables, and a distributed, shared-nothing NDB Cluster en
MySQL executes SQL statements against a connected database, displays results as tables or charts, and supports reusable query files.
Perfetto is a platform for system-level performance tracing and analysis on Linux and Android. It combines a high-throughput trace recorder, a SQL-based query engine, and a browser-based visualizer into a single toolchain. The platform covers CPU scheduling and call-stack profiling, native and Java heap memory allocation tracking, GPU and graphics events, and system-wide counters such as CPU frequency and power consumption. The architecture decouples trace recording from offline analysis, using a compact protobuf format for event encoding and columnar storage for efficient SQL queries. The we
Exposes heap object, class, and reference data as relational tables for custom queries.
Beancount is a plain-text double-entry accounting system. It enforces zero-sum transactions, organizes accounts into a hierarchical five-type tree, and verifies balances at specific dates using precision-derived tolerances. Transactions are recorded in plain-text files with a strict syntax that supports currency-specific rounding, automatic interpolation of missing amounts, and comprehensive metadata including tags, links, and payee annotations. Beyond core bookkeeping, Beancount offers investment portfolio tracking with lot-based cost basis management, configurable booking strategies (FIFO,
Writes SQL-like queries to filter, aggregate, and summarize transaction postings.
This project is a Language Server Protocol implementation for PostgreSQL that provides autocompletion, syntax diagnostics, and type checking for SQL and PL/pgSQL. It functions as a database schema validator and a static analysis engine designed to detect security vulnerabilities, performance bottlenecks, and dangerous migration patterns in database scripts. The server differentiates itself by using live database connections to provide schema-aware intelligence, allowing it to verify that tables, columns, and data types actually exist. It performs static analysis on procedural functions to det
Implements a standardized LSP interface to provide database-aware intelligence and formatting across compatible code editors.
Falcon est un client SQL et gestionnaire de base de données multiplateforme qui offre une interface unifiée pour exécuter des requêtes sur plusieurs systèmes de bases de données. Il fonctionne comme une application de bureau pour Windows et Mac, permettant aux utilisateurs de gérer des données dans divers environnements de bases de données via un éditeur de requêtes unique. L'outil opère comme un studio de données synchronisé avec le cloud, faisant le pont entre les résultats de bases de données locales et le stockage cloud distant. Cela permet le transfert des données de requêtes traitées vers un environnement cloud pour un stockage persistant et une analyse collaborative. Au-delà de l'exécution de requêtes, l'application inclut un utilitaire de visualisation qui convertit les résultats SQL en graphiques interactifs pour l'analyse de données. Ces capacités sont supportées par un système de connectivité basé sur des pilotes et un mécanisme de mise en cache côté client pour la gestion des jeux de résultats.
Provides a unified interactive interface for writing and executing SQL queries across multiple active connections.
Davinci est une plateforme de business intelligence et de visualisation de données utilisée pour construire des tableaux de bord et des rapports interactifs. Elle fonctionne comme un constructeur de tableaux de bord basé sur SQL et un service d'analyse multi-tenant qui se connecte aux bases de données via JDBC et des fichiers CSV pour transformer des données brutes en composants visuels. La plateforme se distingue par son modèle de sécurité granulaire, qui inclut des permissions au niveau des lignes et des colonnes intégrées avec l'authentification LDAP et OAuth2. Elle fournit également un outil de visualisation intégré qui permet d'insérer des graphiques et des tableaux de bord sécurisés et paramétrés dans des applications externes via des URL et des cadres (frames). Le système couvre un large éventail de capacités, y compris la modélisation de données avec des modèles SQL, un moteur de mise en page par glisser-déposer pour les tableaux de bord réactifs, et une grande variété de types de visualisation tels que les diagrammes de Sankey, les graphiques radar et les cartes géographiques. Elle inclut en outre l'automatisation pour la planification de rapports par e-mail et utilise la mise en cache clé-valeur pour optimiser les performances des requêtes.
Provides a dedicated SQL editor with syntax highlighting and templates to define data views.