What are the main features of sqlpad/sqlpad?

The main features of sqlpad/sqlpad are: Web-Based SQL Consoles, SQL Query Libraries, ODBC Managers, Database Connection Configurations, Database Connectivity Interfaces, Database Drivers, Database Schema Inspection, SQL Database Engine Support.

What are some open-source alternatives to sqlpad/sqlpad?

Open-source alternatives to sqlpad/sqlpad include: marmelab/react-admin — React-admin is a framework for building data-driven administrative interfaces that connect to REST or GraphQL… thehive-project/thehive — TheHive is a security incident response platform and multi-tenant case management system. It functions as a Security… dbgate/dbgate — DbGate is a universal database management tool and SQL client that provides a unified interface for querying and… dbeaver/cloudbeaver — CloudBeaver is a web-based database manager and cloud database IDE that provides a centralized browser interface for… supabase-community/supabase-mcp — This project is a Model Context Protocol server and AI agent database connector. It provides a standardized… plotly/falcon — Falcon is a cross-platform SQL client and database manager that provides a unified interface for executing queries…

Sqlpad - exécuter des requêtes SQL dans votre…

Sqlpad est un client SQL basé sur le web et un atelier multi-tenant utilisé pour écrire, exécuter et enregistrer des requêtes sur plusieurs bases de données relationnelles et analytiques. Il fonctionne comme un gestionnaire de base de données ODBC qui permet aux utilisateurs de gérer les connexions aux bases de données et d'explorer les schémas via une interface de navigateur.

La plateforme se distingue comme un environnement collaboratif où les utilisateurs peuvent partager des documents SQL et coordonner l'analyse de données. Elle intègre la fédération d'identité via OpenID Connect, SAML, LDAP et OAuth, et fournit un système de visualisation qui rend les résultats de requêtes sous forme de graphiques et de tableaux.

Le système couvre de vastes domaines de capacités, notamment le contrôle d'accès basé sur les rôles pour restreindre les connexions aux bases de données, la gestion de session avec état pour les transactions à requêtes multiples et la substitution de justificatifs d'identité au moment de l'exécution pour une sécurité renforcée. Il fournit également la persistance des requêtes et le suivi de l'historique pour gérer le cycle de vie des instructions SQL enregistrées.

Features

Web-Based SQL Consoles - Provides a web-based interface for executing SQL queries and managing database connections.
SQL Query Libraries - Grants specific users access to private query documents to collaborate on data analysis.
ODBC Managers - Manages database connections and schema exploration using the ODBC standard for broad compatibility.
Database Connection Configurations - Defines connection strings, credentials, and drivers to establish links to specific database instances.
Database Connectivity Interfaces - Establishes database connections using standard ODBC drivers and connection strings to execute queries.
Database Drivers - Executes queries by routing requests through a standard open database connectivity layer to support multiple database engines.
Database Schema Inspection - Fetches tables and column definitions from a connected database using live requests or cached data.
SQL Database Engine Support - Links to various database engines and compatible sources via ODBC to aggregate data from different origins.
SQL Query Execution - Runs SQL statements against relational and analytical databases and displays results in a web interface.
SQL Query Persistence - Enables the saving and persistence of SQL statements along with connection details and chart configurations.
Multi-Database Queryings - Enables connecting to and querying multiple SQL and NoSQL data sources via a single interface.
Database Schema Explorers - Offers an interactive browser to explore tables and column definitions from connected databases.
Database Access Controls - Restricts access to specific database connections based on user roles and assigned permissions.
SQL Workbenches - Offers a multi-tenant workbench for sharing SQL documents and managing access roles across shared connections.
Role-Based Access Control - Restricts access to specific database connections and administrative features by mapping users to predefined permission levels.
Connection Access Restrictions - Restricts the use of specific database connections to authorized users based on their assigned roles.
User Access Management - Provides centralized management for creating user accounts and assigning roles to control system access.
User Identity Management - Controls application access by authenticating users via email, password, OAuth, OpenID Connect, SAML, or LDAP.
History Tracking - Maintains the status and metadata of past query batches and retains results for a specified duration.
Database Protocol Compatibility - Connects to various SQL and NoSQL databases using specialized drivers to ensure broad data source compatibility.
Query Result Visualizers - Renders the output of SQL executions into visual formats to simplify data analysis.
Database Session Lifecycles - Supports multi-statement transactions and temporary tables by managing the lifecycle of synchronous database sessions.
Batch Statement Execution - Executes a sequence of SQL statements on a database connection while tracking individual status.
Query Result Persistence - Retrieves and persists query outputs as arrays of row data on the file system.
SQL Charting - Executes SQL statements and renders the results as visual charts and tables.
Collaborative Analysis Environments - Provides a collaborative environment for saving and sharing SQL queries to coordinate data analysis workflows.
Connection String Template Mapping - Injects custom user attributes from an authentication proxy into database connection strings using template syntax.
Template-Based Variable Substitution - Replaces connection string placeholders with user-specific attributes at runtime to enforce data-level access control.
Runtime Credential Substitution - Injects user-specific values into database connection settings at runtime to enforce row-level security.
API Request Authentication - Verifies identity via usernames, passwords, or bearer tokens to secure REST API requests.
SAML Integrations - Integrates OIDC, SAML, LDAP, and OAuth to secure access to database connections.
Reverse Proxy Authentication - Automatically creates and authenticates users by mapping request headers provided by an external reverse proxy.
Stateless REST APIs - Decouples the web interface from the backend by exchanging structured data via a stateless API over HTTP.

marmelab/react-admin

26,780Voir sur GitHub

React-admin is a framework for building data-driven administrative interfaces that connect to REST or GraphQL backends. It provides a comprehensive suite of tools for managing the full lifecycle of administrative applications, including resource-oriented routing, declarative form scaffolding, and context-driven state management. By utilizing a modular adapter-based architecture, the framework abstracts backend communication, allowing developers to build consistent CRUD interfaces that handle data fetching, authentication, and synchronization automatically. The project distinguishes itself thr

TheHive-Project/TheHive

3,891Voir sur GitHub

TheHive is a security incident response platform and multi-tenant case management system. It functions as a Security Orchestration, Automation, and Response (SOAR) tool and a threat intelligence platform designed to coordinate security investigations by managing alerts, cases, and observables. The platform is distinguished by its multi-tenant architecture, which isolates data across different organizations while supporting selective cross-tenant sharing. It features a SOAR automation engine capable of executing sandboxed JavaScript logic to automate workflows and trigger response actions thro

Historique des stars

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

dbeaver/cloudbeaver

4,951Voir sur GitHub

CloudBeaver is a web-based database manager and cloud database IDE that provides a centralized browser interface for administering SQL and NoSQL databases. It functions as a multi-database administration tool and an RBAC database access gateway, allowing users to manage diverse relational and document-based database engines through a single server-based installation. The platform distinguishes itself by integrating an artificial intelligence assistant for natural language SQL generation and optimization. It further supports collaborative data engineering by coordinating database operations ac

sqlpadsqlpadArchived

Sqlpad

Features

Alternatives open source à Sqlpad

marmelab/react-admin

TheHive-Project/TheHive

Frequently asked questions

Historique des stars

Frequently asked questions

Alternatives open source à Sqlpad

marmelab/react-admin

TheHive-Project/TheHive

dbgate/dbgate

dbeaver/cloudbeaver