libredb / libredb/libredb-studio

[FEATURE] preview UI improvements with basic operations that does not require raw SQL

Open
#870 0 comments 0 reactions 0 assignees View on GitHub
loop:needs-moderator-action
Dominant language
TypeScript
Stars
726
Forks
119
Avg merge
7h 47m
Merged PRs (30d)
265

Description

## Is your feature request related to a problem?

Improve database preview with basic operations that can be done directly in the UI (as opposed to needing to write SQL).

Example in Drizzle Studio:

- https://demo.drizzle.studio

## Describe the solution you'd like

One or more of these:

- get a quick view of child objects in a sub view

drizzle-studio-preview

- filter
- sort
- column management (visibility selection and rearrange)
- table structure view

data-structure

- for the current sort/filter/column configurations (done in UI), have a way to convert that into a SQL query

The implementation/design doesn't need to match exactly - just any way to more quickly make or view simple changes without needing to type raw SQL will help.

## Describe alternatives you've considered

Using drizzle-studio

## Use Case

For quickly editing data / browsing records without needing to write SQL directly

Contributor guide

Open the contributing guide

Research direction

Start by reviewing the existing database preview UI and comparing it with the requested operations: child-object views, filtering, sorting, column management, structure views, and SQL conversion. The issue does not name files, tests, or a single selected operation, so confirm the scope and define completion criteria before locating the relevant entry points.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql, typescript
Domain
database, frontend
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Active
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.