skills.rest
Aidbox
AidboxOFFICIAL
Explore all skills by this author →
WebsiteGitHub

aidbox-dashboard

Create interactive dashboards from FHIR data using SQL and Chart.js.

18|8|Updated Apr 19, 2024
Search Tags:#data visualization#dashboard#sql#fhir#viewdefinition#aidbox
One-click install
npx skills add https://github.com/Aidbox/examples --skill aidbox-dashboard
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: aidbox-dashboard
Source: https://github.com/Aidbox/examples/tree/main/developer-experience/agentic-coding-dashboard/.claude/skills/aidbox-dashboard
Command: npx skills add https://github.com/Aidbox/examples --skill aidbox-dashboard

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the creation of dynamic dashboards by transforming FHIR data into SQL tables, enabling powerful data visualization and analysis.

Core Features & Use Cases

  • SQL on FHIR: Define ViewDefinitions to materialize FHIR resources into SQL tables.
  • Direct SQL Querying: Connect directly to PostgreSQL using Bun.SQL for efficient data retrieval.
  • Chart.js Integration: Render interactive charts using data queried from materialized views.
  • Use Case: Create a patient demographics dashboard by defining a ViewDefinition for the Patient resource, materializing it, and then querying it with SQL to display patient counts by gender and age group using Chart.js.

Quick Start

Define a ViewDefinition for Patient demographics in fhir/definitions/view-definitions/ and run bun run build:init-bundle --upload to materialize it.

Frequently Asked Questions about aidbox-dashboard

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build a dashboard with SQL queries on top of FHIR data?▼

SQL on FHIR dashboards work by defining ViewDefinitions that materialize FHIR resources into SQL tables. You then query these PostgreSQL tables directly and render the results as interactive charts using Chart.js.

What is the best way to visualize FHIR resources for patient demographics?▼

Visualizing FHIR resources for patient demographics is best done by defining a ViewDefinition for the Patient resource, materializing it into a SQL table, and querying it to display counts by gender and age group using Chart.js.

How do I materialize FHIR resources into SQL tables for analysis?▼

To materialize FHIR resources into SQL tables for analysis, define your ViewDefinition in the designated definitions directory and run the initialization bundle upload command to process and store the structured data in PostgreSQL.

Do I need PostgreSQL to query FHIR data for interactive dashboards?▼

Yes, PostgreSQL is required to query FHIR data for dashboards. The Skill connects directly to PostgreSQL using Bun.SQL to retrieve data from the materialized ViewDefinition tables for visualization.

Can I use Chart.js to display data queried from FHIR materialized views?▼

Yes, you can use Chart.js to display data queried from FHIR materialized views. The Skill integrates Chart.js to render interactive visualizations directly from the SQL data retrieved from your ViewDefinitions.

Related Skills

Explore More Data & Analytics Skills→
HealthSamuraiHealthSamurai
2

aidbox

Manage Aidbox FHIR platform operations including CRUD, searches, transactions, and access policies.

Official
Advanced
EvolutionAPIEvolutionAPI
520

data-build-dashboard

Modernize your workforce's digital toolkit with customizable, secure, scalable, interoperable, user-friendly software that evolves with your business.

Official
Advanced
2025Emma2025Emma
22.7k

postgresql

Provide PostgreSQL development and administration guidance for SQL, schemas, and performance tuning.

Community
Advanced
spqwspqw

observable-framework-lib-duckdb

Integrate DuckDB-Wasm for in-browser SQL analytics in Observable Framework projects.

Community
Intermediate