sqlpad/sqlpadArchived

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.

سجل النجوم