sqlpad/sqlpadArchived
Sqlpad
Sqlpad 是一个基于 Web 的 SQL 客户端与多租户工作台，用于在多个关系型及分析型数据库中编写、执行和保存查询。它作为 ODBC 数据库管理器，使用户能够通过浏览器界面管理数据库连接并探索架构。
该平台作为一个协作环境脱颖而出，用户可以在此共享 SQL 文档并协调数据分析。它集成了通过 OpenID Connect、SAML、LDAP 和 OAuth 实现的身份联合认证，并提供了一个将查询结果渲染为图表与表格的可视化系统。
该系统涵盖了广泛的能力领域，包括用于限制数据库连接的基于角色的访问控制（RBAC）、用于多语句事务的状态化会话管理，以及用于增强安全性的运行时凭据替换。它还提供查询持久化与历史记录追踪，以管理已保存 SQL 语句的生命周期。
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.
