Description
Rosefinch is a simple SQL client for Mac built around saving and reusing your SQL queries. Each database you connect gets its own collection of stored queries, so the query you wrote last week is easy to find again. You can pin favourite queries to the top, jump around with a command bar, and format SQL with one click. A compact schema view shows tables and columns while you write, with search, collapsible tables and a tab for the raw schema dump. Collections can be exported as a single file and shared with teammates by email or Slack, and imported to stay in sync, while query results can be exported as CSV or JSON. Rosefinch works with SQLite, PostgreSQL and MySQL and runs only on macOS. It has no editors for changing schemas or table rows, though you can still do that by running SQL.…
Highlights
- Per-database collections of saved SQL queries
- Pin favourites and navigate with a command bar
- One-click SQL formatting
- Searchable schema overview
- Share query collections as a single file
- Export results as CSV or JSON
Ratings & Reviews
No ratings yet
Be the first to rate Rosefinch.
People also visit
TablePro
A native database client for MySQL, PostgreSQL, SQLite, MongoDB, Redis, and more
Rosefinch FAQ
Which databases does Rosefinch support?
SQLite, PostgreSQL and MySQL.
Which operating systems does it run on?
Only macOS.
Can I edit tables or the schema?
There are no visual tools for changing the schema or table rows, but you can do it by running SQL queries.
How do I share queries with my team?
Export a collection as a single file, send it any way you like, and teammates import it to stay in sync.
What are the best Rosefinch alternatives?
Popular alternatives to Rosefinch include DBcooper, data-peek and pgMagic. See all Rosefinch alternatives



