What does sqlpad/sqlpad do?

Sqlpad 是一个基于 Web 的 SQL 客户端与多租户工作台，用于在多个关系型及分析型数据库中编写、执行和保存查询。它作为 ODBC 数据库管理器，使用户能够通过浏览器界面管理数据库连接并探索架构。

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: datlechin/tablepro — TablePro is a cross-platform database management client designed for browsing, querying, and administering both SQL… 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…

Sqlpad - 在浏览器中运行 SQL 查询

Sqlpad - 在浏览器中运行 SQL 查询 | Awesome Repos

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.

Sqlpad 的开源替代方案

相似的开源项目，按与 Sqlpad 的功能重合度排序。

datlechin/tablepro
datlechin/TablePro
4,471在 GitHub 上查看
TablePro is a cross-platform database management client designed for browsing, querying, and administering both SQL and NoSQL databases. It functions as a unified workspace that integrates a code-centric SQL editor with schema visualization tools, allowing developers to manage complex data models and execute queries across diverse database engines. The application distinguishes itself through an agentic AI integration layer that connects language models directly to database tools, enabling automated query generation, optimization, and error fixing with configurable approval gates. It features
Swift
在 GitHub 上查看4,471
marmelab/react-admin
marmelab/react-admin
26,780在 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
在 GitHub 上查看26,780
thehive-project/thehive
TheHive-Project/TheHive
3,891在 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
在 GitHub 上查看3,891
dbgate/dbgate
dbgate/dbgate
6,769在 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
在 GitHub 上查看6,769