sqlpad/sqlpadArchived
Sqlpad
Sqlpad is a web-based SQL client and multi-tenant workbench used for writing, executing, and saving queries across multiple relational and analytical databases. It functions as an ODBC database manager that enables users to manage database connections and explore schemas through a browser interface.
The platform distinguishes itself as a collaborative environment where users can share SQL documents and coordinate data analysis. It integrates identity federation via OpenID Connect, SAML, LDAP, and OAuth, and provides a visualization system that renders query results into charts and tables.
The system covers broad capability areas including role-based access control to restrict database connections, stateful session management for multi-statement transactions, and runtime credential substitution for enhanced security. It also provides query persistence and history tracking to manage the lifecycle of saved SQL statements.
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.
