--- title: "PriceMedic Replaces AWS with MotherDuck: Case Study | MotherDuck" description: "PriceMedic replaced Athena and Redshift with MotherDuck. Co-founder Josh Nakka on the 14x speedup, $20K/month savings, and Dives for customers." canonical: "https://motherduck.com/videos/pricemedic-data-product-motherduck/" --- [BACK TO VIDEOS](/videos/) [Webinar](/videos/?category=Webinar#videos-and-webinars-library)[MotherDuck Features](/videos/?category=MotherDuck%20Features#videos-and-webinars-library)[AI, ML and LLMs](/videos/?category=AI,%20ML%20and%20LLMs#videos-and-webinars-library) # Building a Data Product on MotherDuck: PriceMedic's Path from Raw Data to Revenue 2026/05/12Featuring: [Mehdi Ouazza](/authors/mehdi-ouazza/) , [Josh Nakka](/authors/josh-nakka/) > **TL;DR:** PriceMedic is a 4-person healthcare pricing data company. They replaced their AWS query stack (Athena, Redshift, SPICE) with MotherDuck, cut query times by 14x, saved roughly $20K/month, and built a hypertenancy architecture that gives every customer isolated compute. They then used MCP and Dives to collapse dashboard creation from tens of hours to under 30 minutes. ## The data and the team PriceMedic sits on a petabyte-scale data lake of US healthcare pricing data: tens of thousands of procedures, thousands of insurance companies, and millions of providers. Co-founder Josh Nakka runs the platform with a 3-person engineering team. Their customers are healthcare provider groups setting procedure prices, and employers shopping for better deals on care. ## Why they left the AWS stack The original stack was native AWS: an S3 Parquet data lake with Athena for ad-hoc petabyte queries and Redshift powering customer-facing analytics. Two problems pushed them off it. Athena was too slow for anything interactive. Redshift cost too much for their actual read patterns, with cold-start latencies above their 7-second tolerance. They were paying for both engines and still not hitting the bar on user experience. This kind of [bloated cloud data warehouse spend](/learn-more/reduce-cloud-data-warehouse-costs-duckdb-motherduck/) is common in analytics shops. ## The hypertenancy architecture Rather than running one big shared cluster, PriceMedic gives every customer their own MotherDuck service account. Each customer's queries hit isolated compute against the same S3 source. This sidesteps the noisy-neighbor problem without provisioning a warehouse per tenant. The S3 lake stays the single source of truth, and the [compute layer on top is swappable](/learn-more/data-lake-vs-data-warehouse-vs-lakehouse/). That separation is how they replaced Athena and Redshift with MotherDuck without touching the lake. ## MCP and Dives in the sales motion The biggest unexpected win was the [MotherDuck MCP server](/product/mcp-server/) paired with Dives. Building a proof-of-concept dashboard for a prospect used to take an engineer several hours in their BI tool. Now an AE can prompt Claude with a prospect's question, MCP runs the queries against the lake, and Dives renders a working app in under 10 minutes. The same prompts that worked in sales started getting embedded into the product as customer-facing views. ## What they ship to customers PriceMedic's first contract with Dives as the primary customer interface is live. Customers can ask their own questions through a governed MCP layer Josh's team built on top, with each customer's data isolated by service account. Internal dashboards the team uses day-to-day are managed via CI on the underlying Dive code. TABLE OF CONTENTS - The data and the team - Why they left the AWS stack - The hypertenancy architecture - MCP and Dives in the sales motion - What they ship to customers Start using MotherDuck now! [Try 7 Days Free](https://auth.motherduck.com/authorize?app_source=web&response_type=code&client_id=bza3KWQpxRAFlTlRFXUo29AOg9xD7zcp&redirect_uri=https%3A%2F%2Fapp.motherduck.com%2F&state=STATE&auth_flow=signup&screen_hint=signup&ext-ph_distinct_id=2f41b434-fe9e-49ae-a755-9b57e1f4b404) ## FAQS ### Why did PriceMedic replace Athena, Redshift, and SPICE with MotherDuck? Athena took over ten minutes on interactive customer queries, which was too slow. Redshift got expensive under the read-heavy workload and still couldn't hit PriceMedic's sub-7-second cold-start target. When they pointed MotherDuck at the same S3 Parquet lake, query times dropped 14x and they saved about $20K a month on infrastructure. The data in S3 didn't change, they just swapped the compute engine sitting on top of it. ### What is the hypertenancy architecture PriceMedic built on MotherDuck? Each customer gets their own MotherDuck service account with isolated compute, all reading from the same shared S3 data lake. No noisy-neighbor problems, no need to spin up a separate warehouse per customer. Because S3 stays the source of truth, PriceMedic can swap out the query engine (Athena, Redshift, MotherDuck, whatever) without touching their storage layer. See [data lake vs data warehouse vs lakehouse](/learn-more/data-lake-vs-data-warehouse-vs-lakehouse/) for how this pattern works. ### How does PriceMedic use MotherDuck MCP and Dives in their sales process? AEs prompt Claude with a real prospect question, the [MotherDuck MCP server](/product/mcp-server/) queries the lake, and a Dive renders a working data app in under 10 minutes. That used to take an engineer several hours, building a custom BI dashboard for each prospect. Some of the Dives created during sales calls actually became the customer-facing experience after the deal closed. ### How big is the PriceMedic team that runs this petabyte data product? Four people, three of them engineers. They stay small by automating their ingestion pipelines and building data flows that self-recover when things break. Infrastructure shouldn't eat engineering time, so most of their work goes into the product and the analytics customers actually see. ## Related Videos [60:29](/videos/ai-agents-semantic-layer/)[2026-08-26](/videos/ai-agents-semantic-layer/) ### [Do AI Agents Need a Semantic Layer?](/videos/ai-agents-semantic-layer/) Do AI agents need a semantic layer? Evals comparing plain-text context with a Malloy semantic layer show where each wins, and what it costs. Stream AI, ML and LLMs BI & Visualization SQL [63:17](/videos/agentic-data-engineering-stack/)[2026-08-18](/videos/agentic-data-engineering-stack/) ### [Beyond Copilots: We're Building a Data Stack Live with AI Agents](/videos/agentic-data-engineering-stack/) Agentic data engineering in practice: AI agents build dlt ingestion into MotherDuck and a governed Lightdash semantic layer, live in an hour. Stream AI, ML and LLMs Data Pipelines Ecosystem [52:41](/videos/guides-context-layer-ai-agents/)[2026-08-13](/videos/guides-context-layer-ai-agents/) ### [Introducing Guides: Warehouse-Native Context for AI Agents](/videos/guides-context-layer-ai-agents/) Guides store business context inside your warehouse so AI agents write correct SQL. See how warehouse-native context works in MotherDuck. Stream AI, ML and LLMs MotherDuck Features [View all](/videos/)