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
coleifer avatar

coleifer/sqlite-web

0
View on GitHub↗

Sqlite Web

sqlite-web is a Python-based web application that provides a graphical user interface for browsing, querying, and editing SQLite database files. It functions as a database management tool that allows users to manipulate table data and manage schemas through a web browser rather than using a command line or raw SQL scripts.

The application includes utilities for data migration, enabling the import and export of database content via JSON and CSV file formats. It also provides secure remote access to databases through password access control and SSL encryption.

The project covers broader administrative capabilities including database connection management, schema administration for modifying tables and columns, and support for deployment via WSGI services.

AI search

Explore more awesome repositories

Describe what you need in plain English — the AI ranks thousands of curated open-source projects by relevance.

Start searching with AI

Features

  • Web-Based Database Browsers - Provides a web-based interface to browse table data and perform manual CRUD operations.
  • Schema Administration - Allows defining and modifying SQLite table structures, columns, and indexes through a graphical interface.
  • Data Schema Management - Enables defining and modifying the database structure, including creating and altering tables and columns.
  • SQL Database Management - Acts as a management tool for relational database instances, allowing schema and data manipulation.
  • SQLite Database Management - Provides a complete suite of tools for managing, querying, and editing SQLite databases via a web browser.
  • SQLite Integration - Connects directly to SQLite database files using a native driver for query execution.
  • SQL Data Exporters - Converts SQLite table contents into portable CSV or JSON file formats.
  • Bulk Data Migrations - Facilitates the movement of SQLite table data to and from external JSON or CSV files.
  • Database Connection Management - Manages the lifecycle of connections by loading and unloading SQLite database files at runtime.
  • External File Imports - Allows loading information from JSON or CSV files directly into database tables.
  • File-Based Data Exports - Provides utilities to export database content into portable JSON and CSV file formats.
  • Web-Based Database Clients - Offers secure, password-protected remote access to SQLite databases via a web browser.
  • Request Authentication Middleware - Uses middleware to intercept HTTP requests and verify password credentials before granting access.
  • Python Web Frameworks - Built as a server-side Python web application to provide a GUI for local database files.
  • Flask Framework Implementations - Implemented as a web application using the Flask framework to handle routing and template rendering.
  • Template-Driven Rendering - Generates the user interface by injecting database schema and row data into server-side HTML templates.
  • Web - Listed in the “Web” section of the Awesome Sqlite awesome list.
4,117 stars·399 forks·Python·MIT·40 views

Star history

Star history chart for coleifer/sqlite-webStar history chart for coleifer/sqlite-web

How this analysis was created: This summary and feature list are AI-generated from collected project material and can contain mistakes. Stars, license and language are imported from GitHub. Inclusion does not mean that we have tested or audited this project. Check the source documentation for any feature you depend on. Learn more on our About page.

Frequently asked questions

What does coleifer/sqlite-web do?

sqlite-web is a Python-based web application that provides a graphical user interface for browsing, querying, and editing SQLite database files. It functions as a database management tool that allows users to manipulate table data and manage schemas through a web browser rather than using a command line or raw SQL scripts.

What are the main features of coleifer/sqlite-web?

The main features of coleifer/sqlite-web are: Web-Based Database Browsers, Schema Administration, Data Schema Management, SQL Database Management, SQLite Database Management, SQLite Integration, SQL Data Exporters, Bulk Data Migrations.

Which projects share features with coleifer/sqlite-web?

Projects with overlapping indexed features include: datlechin/tablepro — TablePro is a cross-platform database management client designed for browsing, querying, and administering both SQL… pylons/pyramid — Pyramid is a Python web framework and WSGI toolkit designed for building web applications. It functions as a URL… outerbase/studio — Studio is a containerized SQL database management tool that provides a browser-based graphical interface for executing… pawelsalawa/sqlitestudio — SQLiteStudio is an open-source graphical tool for browsing, editing, and managing SQLite database files. It combines a… kuzudb/kuzu — Kùzu is an embedded property graph database engine designed for high-performance analytical queries and local data… answerdotai/fasthtml — FastHTML is a full-stack Python web framework designed for building interactive web applications using pure Python. It…

Projects sharing features with Sqlite Web

These projects share indexed features with Sqlite Web. Shared tags can include platform or build tooling; verify the primary use case before treating a result as a replacement.
  • datlechin/tableprodatlechin avatar

    datlechin/TablePro

    4,471View on 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
    View on GitHub↗4,471
  • pylons/pyramidPylons avatar

    Pylons/pyramid

    4,086View on GitHub↗

    Pyramid is a Python web framework and WSGI toolkit designed for building web applications. It functions as a URL routing engine that maps incoming HTTP requests to specific view callables using both pattern-based routing and hierarchical resource tree traversal. The framework is distinguished by its hybrid dispatch system, allowing developers to combine regular expression URL matching with the ability to resolve requests by navigating a tree of nested objects. It implements a flexible component architecture that supports application registry management, deferred configuration execution, and t

    Pythonpylonspyramidpython
    View on GitHub↗4,086
  • outerbase/studioouterbase avatar

    outerbase/studio

    5,818View on GitHub↗

    Studio is a containerized SQL database management tool that provides a browser-based graphical interface for executing queries and managing data across various SQL databases. It consists of a specialized query editor and a graphical administration interface designed for web-based database administration. The project features a high-performance SQL query editor with auto-completion and function hints for running multiple database commands simultaneously. It includes a visual schema editor for creating and modifying table columns and a record editor that stages and previews changes before they

    TypeScript
    View on GitHub↗5,818
  • 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

    Ccppdatabasedatabase-management
    View on GitHub↗6,428
Compare all 30 related projects→