awesome-repositories.com
Blog
MCP
awesome-repositories.com

Discover the best open-source repositories with AI-powered search.

ExploreCurated searchesOpen-source alternativesSelf-hosted softwareBlogSitemap
ProjectMCP serverAboutHow we rankPress
LegalPrivacyTerms
© 2026 Bringes Technology SRL·VAT RO45896025·hello@awesome-repositories.com

web-based database administration tool

Ranking updated Jun 30, 2026

For a web based interface for managing databases, the first results are ottermind/chat2db, mathesar-foundation/mathesar and phpmyadmin/phpmyadmin (phpMyAdmin is a classic web-based administration interface for MySQL and MariaDB, providing SQL query editing, schema design, import/export, and user access control directly in the browser — it squarely fits the need for a visual, self-hostable database tool). vrana/adminer and sqlpad/sqlpad round out the shortlist. Compare the match explanations and check the project documentation against your requirements.

We curate open-source GitHub repositories matching “database management interfaces”. Results are ranked by relevance to your query — pick filters below to narrow, or refine with AI.

Results for “a web based interface for managing databases”

Find the best repos with AI.We'll search the best matching repositories with AI.
  • ottermind/chat2dbOtterMind avatar

    OtterMind/Chat2DB

    25,784View on GitHub↗

    Chat2DB is an AI-powered SQL client and multi-database GUI manager designed for managing various relational and NoSQL database systems. It serves as a visual database management tool and a natural language to SQL interface, allowing users to convert plain text descriptions into executable and optimized queries. The platform distinguishes itself through automated business intelligence capabilities, which include the generation of real-time data visualization dashboards and AI-driven data analysis from spreadsheets. To ensure data privacy, it supports secure local AI deployment, enabling large

    Chat2DB is an AI-enhanced multi-database GUI manager that provides a visual, self-hostable interface for querying and administering databases, directly meeting your need for a web-based administration tool with strong support for SQL editing, schema management, import/export, and role-based access control.

    JavaData Import and ExportDatabase Schema DesignersRole-Based Access Control
    View on GitHub↗25,784
  • mathesar-foundation/mathesarmathesar-foundation avatar

    mathesar-foundation/mathesar

    5,012View on GitHub↗

    Mathesar is a no-code database manager and PostgreSQL GUI that provides a visual interface for managing relational database structures and records. It functions as a low-code data platform for administering schemas, tables, and relationships without the need to write manual SQL commands. The platform allows for the creation of shareable forms to collect data and the management of file attachments linked directly to database records. It includes a PostgreSQL administration tool for controlling database roles, user permissions, and data validation rules. The system covers relational data model

    Mathesar is a self-hosted web-based PostgreSQL GUI that lets you visually manage schemas, tables, roles, and permissions, and supports data import/export—so it matches the search for a web-based database administration tool, but it is limited to PostgreSQL rather than supporting multiple database engines like the query expects.

    SvelteData Import and ExportDatabase Schema DesignersRole-Based Access Control
    View on GitHub↗5,012
  • phpmyadmin/phpmyadminphpmyadmin avatar

    phpmyadmin/phpmyadmin

    7,887View on GitHub↗

    phpMyAdmin is a web-based interface for administering MySQL and MariaDB databases. Written in PHP, this relational database administrator allows users to perform common database tasks through a browser instead of a command line. The tool provides a graphical interface for database schema design, including the creation and modification of tables, columns, and indexes. It also enables web-based SQL querying to analyze or modify data and handles general server administration for both MySQL and MariaDB.

    phpMyAdmin is a classic web-based administration interface for MySQL and MariaDB, providing SQL query editing, schema design, import/export, and user access control directly in the browser — it squarely fits the need for a visual, self-hostable database tool.

    PHPDatabase Schema Designers
    View on GitHub↗7,887
  • vrana/adminervrana avatar

    vrana/adminer

    7,432View on GitHub↗

    Adminer is a PHP-based database management tool and multi-engine database client. It provides a web-based graphical interface for administering various relational and document database engines. The application is distributed as a single file to simplify installation and deployment on web servers. It supports customization through external stylesheets for visual themes and a plugin architecture to extend core functionality and system behaviors. The tool covers database schema administration, including the creation of views and management of foreign keys. It includes a SQL query editor with au

    Adminer is a self-hostable PHP-based web interface for managing multiple database engines (MySQL, PostgreSQL, SQLite, etc.), featuring an SQL query editor, schema administration, and data import/export, though it lacks built-in user role management, making it the right kind of tool but not the most feature-complete for this search.

    PHPSchema Management ToolsSQL Query Editors
    View on GitHub↗7,432
  • sqlpad/sqlpadsqlpad avatar

    sqlpad/sqlpad

    5,186View on GitHub↗

    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. Th

    Sqlpad is a web-based SQL client and workbench that supports multiple databases, schema browsing, user authentication, and self-hosting, making it a solid fit for administering databases through a browser.

    JavaScriptRole-Based Access Control
    View on GitHub↗5,186
  • teableio/teableteableio avatar

    teableio/teable

    21,346View on GitHub↗

    Teable is a self-hosted relational data management tool and no-code PostgreSQL database. It provides a spreadsheet-like interface for managing and querying structured data, allowing users to interact with a professional database backend without writing manual SQL for every operation. The platform is an extensible low-code system that allows for the integration of custom plugins and extensions through a dedicated application bridge and marketplace. It enables the creation of tailored internal tools by adding new features or modifying behavior via these external extensions. The system covers a

    Teable is a self-hosted web-based relational data management tool with a spreadsheet-like interface and SQL query capabilities, supporting PostgreSQL and SQLite, which directly fits the need for a visual database administration interface with multi-database support and self-hosting.

    TypeScriptNo-Code Database InterfacesRelational Data StorageData Analysis & Visualization
    View on GitHub↗21,346
  • sosedoff/pgwebsosedoff avatar

    sosedoff/pgweb

    9,399View on GitHub↗

    pgweb is a web-based database client and graphical administration tool for PostgreSQL. It provides a browser-based interface for executing SQL queries, inspecting schemas, and managing database objects. The tool includes a read-only mode that prevents destructive operations by blocking specific SQL keywords. It supports secure remote access to private instances through native SSH tunneling and encrypted database connections. The application covers a broad range of management capabilities, including multi-environment session management, database structure inspection, and the export of query r

    pgweb is a web-based PostgreSQL administration tool that covers SQL editing, schema browsing, and data export, fitting the core category of database management, though it only supports PostgreSQL rather than multiple database engines.

    GoDatabase Administration InterfacesPostgreSQL Administration ToolsDatabase Management Consoles
    View on GitHub↗9,399
  • nocodb/nocodbnocodb avatar

    nocodb/nocodb

    63,466View on GitHub↗

    NocoDB is a visual platform that transforms relational databases into collaborative, spreadsheet-style workspaces. By acting as a headless database backend, it provides a unified environment for designing database structures, managing record relationships, and interacting with data without requiring manual SQL queries. The platform normalizes interactions across various SQL and NoSQL data sources, allowing users to manage complex datasets through a centralized interface. The project distinguishes itself by automatically generating RESTful and GraphQL APIs from existing database schemas, enabl

    NocoDB is a self-hostable, web-based visual platform for managing relational and NoSQL databases, covering schema design, import/export, and user roles, though its no-code focus means it may lack a traditional SQL query editor with syntax highlighting.

    TypeScriptBasesData Access & AbstractionDynamic REST API Generators
    View on GitHub↗63,466
  • chartdb/chartdbchartdb avatar

    chartdb/chartdb

    21,286View on GitHub↗

    ChartDB is a database schema visualizer and entity-relationship diagramming platform designed to help developers understand, design, and document complex data architectures. It functions as a visual workspace where users can create and modify database schemas, define table attributes, and map foreign key relationships. By parsing database metadata or SQL scripts, the tool generates interactive diagrams that provide a clear overview of structural interdependencies and data associations. The platform distinguishes itself through its focus on automated documentation and schema synchronization. I

    ChartDB is a database schema visualizer and ER-diagramming tool focused on design and documentation, not a full administration interface with a SQL query editor, data import/export, or user authentication, so it's a neighbouring tool for schema exploration rather than the web-based admin tool you're looking for.

    TypeScriptDatabase Schema DesignersDatabase Schema ManagersDatabase Table Editors
    View on GitHub↗21,286
  • pawelsalawa/sqlitestudiopawelsalawa avatar

    pawelsalawa/sqlitestudio

    6,428View on GitHub↗

    SQLiteStudio is an open-source graphical tool for browsing, editing, and managing SQLite database files. It combines a full-featured SQL editor with syntax highlighting, a visual database schema designer for creating entity-relationship diagrams, and a plugin-based extensibility platform that allows adding custom functionality through C/C++, JavaScript, Tcl, or Python. The application distinguishes itself through its multi-language scripting engine, which embeds JavaScript, Tcl, and Python interpreters to enable user-defined functions and scripts within SQL queries. It supports encrypted data

    SQLiteStudio is a desktop GUI for managing SQLite databases locally, but it is not web-based, does not support multiple database engines, and cannot be self-hosted as a web interface, so it falls short of the full category you are after.

    CData Import and ExportDatabase Schema DesignersSQL Query Editors
    View on GitHub↗6,428
  • liquibase/liquibaseliquibase avatar

    liquibase/liquibase

    5,527View on GitHub↗

    Liquibase is a database schema change management tool and version control system designed to track, manage, and apply versioned database modifications. It functions as a SQL migration framework and DevOps automation utility that integrates database deployments into continuous delivery pipelines and build toolchains. The system enables precise rollbacks and drift detection by recording every modification made to a database schema. It supports the definition of database changes through structured changesets in XML, YAML, or JSON, as well as raw SQL scripts, to ensure consistent deployments acro

    Liquibase is a database schema migration and version control tool, not a visual web-based interface for administering databases, so it does not match the core requirement of a web-based database administration tool.

    JavaDatabase Engine SupportDatabase Schema Managers
    View on GitHub↗5,527
  • d2-projects/d2-admind2-projects avatar

    d2-projects/d2-admin

    12,643View on GitHub↗

    d2-admin is an admin dashboard framework used to build back-office management interfaces. It provides a set of pre-configured layouts and themeable components, including foldable sidebars and draggable grid systems, to facilitate system oversight and control. The framework is distinguished by its multi-tab administration interface, which allows users to switch between pages and reorder tabs via drag and drop. It also features a dynamic translation system for multi-language interface localization and a dedicated toolset for tabular data management, enabling the import and export of data via CS

    This is a framework for building admin dashboards, not a ready-to-use database administration tool — it lacks built-in multi-database support, SQL editing, or schema management, so it is a building block for such tools rather than the tool itself.

    JavaScriptData Import and ExportData Import and Export
    View on GitHub↗12,643
Compare the top 10 at a glance
RepositoryStarsLanguageLicenseLast push
ottermind/chat2db25.8KJavaApache-2.0Jun 18, 2026
mathesar-foundation/mathesar5KSvelteGPL-3.0Jun 22, 2026
phpmyadmin/phpmyadmin
7.9K
PHP
GPL-2.0
Jun 14, 2026
vrana/adminer7.4KPHPNOASSERTIONMar 18, 2026
sqlpad/sqlpad5.2KJavaScriptMITAug 23, 2025
teableio/teable21.3KTypeScriptNOASSERTIONJun 16, 2026
sosedoff/pgweb9.4KGoMITJun 9, 2026
nocodb/nocodb63.5KTypeScriptNOASSERTIONJun 16, 2026
chartdb/chartdb21.3KTypeScriptagpl-3.0Feb 11, 2026
pawelsalawa/sqlitestudio6.4KCotherFeb 20, 2026

Related searches

  • a self-hosted web database admin
  • a visual database management tool for queries
  • an open source database management tool
  • a relational database management system for data
  • an open source database for application data
  • a desktop client for my SQL databases
  • a modern phpMyAdmin alternative
  • an open source database for application development