Alternatives
Products that do what SqlOptimizer does
Stop Re-pasting & Start Optimizing
- 1PI
This is a Postgres extension that can determine if a query should have an index. For example, for this table: create table book( id int primary key, title text not null ); You can run `index_advisor()` to see if there should be an index on a select statement: select * from index_advisor('select book.id from book where title = $1'); And it will return (summarized): {"CREATE INDEX ON public.book USING btree (title)"} It works particularly well with pg_stat_statements[0] which tracks execution statistics of all SQL statements executed on your Postgres database. It leans heavily on HypoPG[1], an…
2024 · github.com
- 2
- 3
- 4
- 5
- 6BP
Hi HN! We're Evgeny and Arjun, and we’re building a better way to do analytics with Postgres. We love Postgres for its simplicity, power, and rich ecosystem. But engineers have to still get bogged down with heavyweight and expensive OLAP systems when connecting an analytics data stack. Postgres is amazing at OLTP queries, but not for OLAP queries (large data scans and aggregations). Even in this case, we’ve still heard from countless scaling startups that they still try to use only a read replica to run analytics workloads since they don’t want to deal with the data engineering complexity of…
2024 · github.com
- 71Y
I have spent large parts of the last 10+ years building an SQL Editor. The tool is targeted at data analysts, a lot of effort has gone into charting, visualizing and excel export. If this sounds useful to you, it's Free, please give it a try and let me know any feedback.
2024 · timestored.com
- 8PT
PgQueuer is a minimalist, high-performance job queue library for Python, leveraging the robustness of PostgreSQL. Designed for simplicity and efficiency, PgQueuer uses PostgreSQL's LISTEN/NOTIFY to manage job queues effortlessly.
2024 · github.com
- 9
- 10SE
I have been working on SQL Explorer, an open source, Django-based reporting and query tool for (gulp!) almost ten years. It's a tool that fits just right for me and many others, and I love and use almost every day. Write SQL, share results, do some analysis, get insight. No surprises. A live demo instance is here (no login or anything required): https://demo.sqlexplorer.io/ And here's a fairly unprofessional, but very enthusiastic, video tour: https://sql-explorer.s3.amazonaws.com/Sql+Explorer+5.mp4 The UI is constrained enough that there's very little to learn,…
2024 · github.com
- 11
- 12
- 13
- 14
- 15VS
My co-worker and I were debugging a SQL issue; having not seen SQL in two years, I embarrassed myself by confusing union vs. join. After this episode, I tried refreshing my SQL memory, but there are few websites that animate SQL for you. Most of them just have a series of images to help you visualize. There are a few tools that are quite good and robust (especially for large/complex use cases) but require installation and are too complex for my simple purpose. So, just created a small tool to help visualise SQL. Most of the animations are just my understanding of how SQL works. Would…
2022 · animatesql.com
- 16
- 17
- 18
- 19
- 20AD
Hey HN, Postgres Pro is an open source Model Context Protocol (MCP) server built to support every stage of the development process. It does a lot more than help generate and run SQL—it helps you make sure your application and database actually run well. Features: - Industrial-strength tuning algorithms similar to those in MS SQL Server - “What if?” tool to evaluate LLM-generated index suggestions - Works with Cursor, etc., to make changes in ORM code - Ensures safe SQL execution with restricted mode - Includes health checks to stay ahead of production problems
2025 · github.com
- 21PA
2024 · github.com
- 22PP
Hey! I'm Andrei. I got frustrated by how people tend to build overcomplicated backend systems, being "motivated" by big tech case studies and popular books. So, I started exploring lean architecture, and building my digital garden of ideas, approaches and data that align with this direction. Here I want to present one of the tools – Sizing tool for PostgreSQL. I've benchmarked PostgreSQL on different EC2 instances and disks, with different initial data sets to see performance that these instances can give you. And I've built a tool to visualize this data, which I welcome you to explore. So,…
Jul 2026 · postgres.saneengineer.com
- 23SD
My name is Weston Goodwin. I created a tool called SQL Simulator which allows you to do Dry Runs with your SQL Scripts. The reason I created the tool was because I wanted to verify that my SQL scripts did what I thought they would do without executing them against the database. It is similar in concept to Redgate SQL Clone or Windocs. If you are not familiar with these tools they make clones of your database. The key difference with SQL Simulator is, it only makes a clone of the database objects affected by your sql script, not the entire database. Nor does it copy the entire table (if your…
2023 · tribalknowledge.tech
- 24PP
2022 · github.com
Ranked by how close each launch is in meaning, then by votes. Refine with a description →