PostgresML

PostgresML is an open-source extension for PostgreSQL that enables machine learning directly within the database. It allows users to train, deploy, and run machine learning models using SQL queries, eliminating the need to move data between the database and external ML tools. This integration helps reduce latency, improve performance, and simplify the architecture for ML-driven applications.

We’re a humble team of engineers, academics and creatives primarily located on earth.

As a Founding Product Designer I shaped the product’s design strategy and created a seamless user experience that integrated machine learning into everyday workflows. I built a scalable design system and worked closely with Product Managers and Engineers to make sure our teams were aligned. I also set up processes to improve how we worked together, streamlining collaboration between engineering and product.

Key features

  • In-Database Machine Learning: Train and serve models without leaving PostgreSQL.

  • Support for Popular Libraries: Integrates with ML libraries like scikit-learn, XGBoost, and more.

  • Real-Time Predictions: Enables real-time inference through simple SQL queries.

  • Scalable Architecture: Optimized for high performance with support for large datasets.

Our story

PostgresML was founded in 2022 by the engineers who built (and rebuilt) Instacart’s machine learning platform.

In the midst of the Covid-19 pandemic — and the company’s highest-ever growth period — they found that the data infrastructure for machine learning at scale was too complex and data hungry to reliably deliver fast and efficient systems.

They created a platform that eliminated microservices and moved the models right into the database. They saw dramatic performance improvements to their search and recommendation apps along with an increase (from 9 months to 1 week!) in development cycles.

PostgresML was created to provide the same critical infrastructure to today’s ML/AI apps and their practitioners. Whether it’s RAG or search; PostgresML users can access the same in-database platform to set up, train, test and run state-of-the-art models in a single solution.

Case studies

Design system


All designs are here.

Next
Next

Sundry