# Clinical Knowledge Graph Demo

> See how PuppyGraph maps patient journeys, uncovering complex healthcare data relationships for real-time insights with zero ETL and seamless graph analytics.

- Canonical URL: https://www.puppygraph.com/demo-videos/clinical-knowledge-graph-demo
- Video: https://www.youtube.com/watch?v=U4E7MpkCu1Y
- Category: Use case

In this demo, we explore the rich dataset of Drug Central to demonstrate the power of PuppyGraph in the pharmaceutical sector. By seamlessly querying across diverse data stores like Iceberg and PostgreSQL, users can efficiently retrieve FDA-approved drugs and explore drugs' mechanisms of action on human targets. This capability not only enhances drug discovery processes but also supports quick, informed decision-making in pharmaceutical research by providing access to comprehensive drug information in real-time.

## Tech stack

-   PuppyGraph
-   Apache Iceberg
-   Docker
-   PostgreSQL

## Queries in natural language

-   List the drugs approved by FDA, limiting the number of returned results
-   Get drugs with mechanisms of action for human targets, returning 50 results (This operation queries data from both Iceberg and PostgreSQL)

[Visit the GitHub repository](https://github.com/puppygraph/puppygraph-getting-started/tree/main/use-case-demos/clinical-knowledge-graph-demo)