# SQLiter: A Web-Based SQLite Database Editor with Go Backend and React Frontend

This repository profile is provided by osrepos.com, an open source repository discovery platform.

Source: osrepos.com
Repository profile: https://osrepos.com/repo/ronreiter-sqliter
Generated for open source discovery and AI-assisted research.

SQLiter is a powerful web-based SQLite database editor, offering a comprehensive interface for browsing, editing, and managing SQLite databases. Built with a Go backend and React frontend, it provides advanced features for data manipulation, querying, and schema management, all packaged as a single executable. This tool is ideal for developers and data analysts seeking an efficient and user-friendly SQLite GUI.

GitHub: https://github.com/ronreiter/sqliter
OSRepos URL: https://osrepos.com/repo/ronreiter-sqliter

## Summary

SQLiter is a powerful web-based SQLite database editor, offering a comprehensive interface for browsing, editing, and managing SQLite databases. Built with a Go backend and React frontend, it provides advanced features for data manipulation, querying, and schema management, all packaged as a single executable. This tool is ideal for developers and data analysts seeking an efficient and user-friendly SQLite GUI.

## Topics

- SQLite
- Database Editor
- Web Interface
- Go
- React
- TypeScript
- Data Management
- Open Source

## Repository Information

Last analyzed by OSRepos: Sat May 09 2026 21:52:16 GMT+0100 (Western European Summer Time)
Detail views: 5
GitHub clicks: 6

## Safety Notice

OSRepos shares public repositories for knowledge and discovery only. Review source code, dependencies, licenses, and security implications before running or installing anything.

## Content

## Introduction

SQLiter is a powerful web-based SQLite database editor designed to provide a comprehensive interface for browsing, editing, and managing SQLite databases. It features a robust Go backend and a modern React frontend, all packaged conveniently as a single executable. SQLiter offers advanced capabilities for data manipulation, querying, and schema management, making it an ideal tool for developers and data analysts. Key features include full CRUD operations, advanced filtering and sorting, a powerful SQL editor with syntax highlighting, and data export options.

## Installation

Getting started with SQLiter is straightforward, whether you prefer using Docker or building from source.

### Using Docker

To quickly deploy SQLiter with Docker:

bash
# Build the Docker image
docker build -t sqliter .

# Run with your database
docker run -p 2826:2826 -v /path/to/your/database.db:/data/database.db sqliter --db /data/database.db


### Building from Source

For those who prefer to build the application directly:

bash
# Build everything using task commands
task build

# Run with your database
./sqliter --db example.db


Alternatively, you can build the frontend and backend manually:

1.  **Build the frontend**:
    bash
    cd web
    npm install
    npm run build
    cd ..
    
2.  **Build the Go application**:
    bash
    go build -o sqliter ./cmd/main.go
    
3.  **Run the application**:
    bash
    ./sqliter --db your-database.db
    

## Examples

Once SQLiter is running, typically accessible at `http://localhost:2826`, you can begin interacting with your SQLite databases.

### Working with Data

*   **Viewing Data**: Select any table from the left sidebar to display its contents in the main area.
*   **Editing Cells**: Double-click any cell directly in the table to edit its value inline.
*   **Adding Rows**: Use the green row at the bottom of the table or click the "Add Row" button to insert new records.
*   **Filtering**: Click the "Filters" button to reveal column-specific filters, allowing you to narrow down your data.
*   **Sorting**: Click column headers to sort data in ascending, descending, or unsorted order.
*   **Bulk Operations**: Select multiple rows using checkboxes to perform batch actions.

### SQL Editor

The integrated SQL Editor provides a powerful environment for custom queries:

1.  **Navigate**: Go to the SQL Editor tab.
2.  **Write Query**: Enter your SQL query in the editor, which supports syntax highlighting and auto-completion.
3.  **Execute**: Press `Ctrl+Enter` or click "Run Query" to execute your SQL.
4.  **View Results**: The results will be displayed in a formatted table below the editor.
5.  **Export**: If needed, export the query results to CSV format.

## Why Use SQLiter?

SQLiter stands out as a comprehensive and user-friendly solution for SQLite database management. Its modern web-based interface, built with React and Tailwind CSS, ensures a responsive and intuitive user experience. The application's single executable design simplifies deployment, while its Go backend provides efficient performance. With features like full CRUD operations, intelligent inline editing, advanced filtering with persistence, multi-level sorting, and a robust SQL editor, SQLiter empowers users to efficiently explore, manipulate, and maintain their SQLite databases. It's an excellent choice for anyone needing a powerful yet accessible SQLite GUI.

## Links

*   GitHub Repository: [ronreiter/sqliter](https://github.com/ronreiter/sqliter){:target="_blank"}