Stop gluing Pinecone, Redis, and Python scripts together. ShapedQL is the SQL engine for relevance - powering "For You" feeds, Search, and RAG memory in minutes. It compiles simple SQL into real-time ranking pipelines that retrieve, filter, score, and reorder results based on live user behavior. Replace thousands of lines of infra with 30 lines of SQL. With native multi-modal embeddings and automated MLOps, ShapedQL helps you build real-time decisions, not just document retrieval.
I'm Tullie, the founder and CEO of Shaped. Previously I was a researcher at Meta AI, leading several ML teams including one focused on Instagram Reels and Ads video ranking. I also created PyTorchVideo and was a core contributor to Pytorch Lightning.
We built ShapedQL because we realized that while retrieval has become easier (thanks to Vector DBs), ranking and relevance are still incredibly hard.
Most engineering teams we talk to are stuck maintaining a "Frankenstein" stack. To build a "For You" feed or give an AI Agent personalized memory, they have to glue together a vector database, a feature store (like Redis), a reranking service, and thousands of lines of Python spaghetti code.
We built ShapedQL to turn that "house of cards" into a single interface.
ShapedQL is a domain-specific SQL dialect that compiles down to a high-performance, multi-stage ranking pipeline. With a single query, you can define the four stages of modern relevance: 1. Retrieve: Fetch candidates from multiple sources (Hybrid Search, Collaborative Filtering, Trending). 2. Filter: Apply hard constraints (e.g., "in stock" or "within 50 miles"). 3. Score: Rank results using real-time ML models (optimizing for clicks, purchases, or watch time). 4. Reorder: Enforce diversity so your users (or Agents) don't see the same 5 items repeatedly.
We're seeing teams reduce 2,000+ lines of maintenance code down to ~30 lines of ShapedQL, while shipping features like "Cart Upsell" or "Agent Memory" in days instead of months.
If you're not a fan of SQL you can also choose from Python or Typescript SDK's.
I'd love to hear your feedback and answer any questions about the syntax or how it works under the hood! 🚀
About ShapedQL on Product Hunt
“The SQL engine for search, feeds, and AI agents”
ShapedQL launched on Product Hunt on January 27th, 2026 and earned 213 upvotes and 22 comments, placing #5 on the daily leaderboard. Stop gluing Pinecone, Redis, and Python scripts together. ShapedQL is the SQL engine for relevance - powering "For You" feeds, Search, and RAG memory in minutes. It compiles simple SQL into real-time ranking pipelines that retrieve, filter, score, and reorder results based on live user behavior. Replace thousands of lines of infra with 30 lines of SQL. With native multi-modal embeddings and automated MLOps, ShapedQL helps you build real-time decisions, not just document retrieval.
On the analytics side, ShapedQL competes within Software Engineering, Developer Tools and Artificial Intelligence — topics that collectively have 1M followers on Product Hunt. The dashboard above tracks how ShapedQL performed against the three products that launched closest to it on the same day.
Who hunted ShapedQL?
ShapedQL was hunted by Garry Tan. A “hunter” on Product Hunt is the community member who submits a product to the platform — uploading the images, the link, and tagging the makers behind it. Hunters typically write the first comment explaining why a product is worth attention, and their followers are notified the moment they post. Around 79% of featured launches on Product Hunt are self-hunted by their makers, but a well-known hunter still acts as a signal of quality to the rest of the community. See the full all-time top hunters leaderboard to discover who is shaping the Product Hunt ecosystem.
Hi Product Hunt! 👋
I'm Tullie, the founder and CEO of Shaped. Previously I was a researcher at Meta AI, leading several ML teams including one focused on Instagram Reels and Ads video ranking. I also created PyTorchVideo and was a core contributor to Pytorch Lightning.
We built ShapedQL because we realized that while retrieval has become easier (thanks to Vector DBs), ranking and relevance are still incredibly hard.
Most engineering teams we talk to are stuck maintaining a "Frankenstein" stack. To build a "For You" feed or give an AI Agent personalized memory, they have to glue together a vector database, a feature store (like Redis), a reranking service, and thousands of lines of Python spaghetti code.
We built ShapedQL to turn that "house of cards" into a single interface.
ShapedQL is a domain-specific SQL dialect that compiles down to a high-performance, multi-stage ranking pipeline. With a single query, you can define the four stages of modern relevance:
1. Retrieve: Fetch candidates from multiple sources (Hybrid Search, Collaborative Filtering, Trending).
2. Filter: Apply hard constraints (e.g., "in stock" or "within 50 miles").
3. Score: Rank results using real-time ML models (optimizing for clicks, purchases, or watch time).
4. Reorder: Enforce diversity so your users (or Agents) don't see the same 5 items repeatedly.
We're seeing teams reduce 2,000+ lines of maintenance code down to ~30 lines of ShapedQL, while shipping features like "Cart Upsell" or "Agent Memory" in days instead of months.
If you're not a fan of SQL you can also choose from Python or Typescript SDK's.
I'd love to hear your feedback and answer any questions about the syntax or how it works under the hood! 🚀