What does sqlpad/sqlpad do?

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.

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 - run SQL queries in your browser

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.

Open-source alternatives to Sqlpad

Similar open-source projects, ranked by how many features they share with Sqlpad.

marmelab/react-admin
marmelab/react-admin
26,780View on 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
TypeScriptadminadmin-dashboardadmin-on-rest
View on GitHub26,780
thehive-project/thehive
TheHive-Project/TheHive
3,891View on 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
Scalaanalyzerapicortex
View on GitHub3,891
dbgate/dbgate
dbgate/dbgate
6,769View on GitHub
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
Sveltecassandraclickhousecockroachdb
View on GitHub6,769
dbeaver/cloudbeaver
dbeaver/cloudbeaver
4,951View on 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
TypeScriptcloudcloud-database-managerdatabase
View on GitHub4,951

See all 30 alternatives to Sqlpad

Sqlpad - run SQL queries in your browser | Awesome Repos

sqlpadsqlpadArchived

Sqlpad

Features

Open-source alternatives to Sqlpad

marmelab/react-admin

TheHive-Project/TheHive

dbgate/dbgate

dbeaver/cloudbeaver

Frequently asked questions

Star history

Open-source alternatives to Sqlpad

marmelab/react-admin

TheHive-Project/TheHive

dbgate/dbgate

dbeaver/cloudbeaver

Frequently asked questions