Back to Templates

SQL database explorer

shiny create -m core \
  -g https://github.com/posit-dev/py-shiny-templates/tree/main/database-explorer

Run queries on an SQL database and view the results in a data grid. This app demonstrates how to initialize, populate, and connect to an SQL database using the duckdb package. It also shows how to run SQL queries and display results in an interactive data grid. Note also the use of Shiny modules to encapsulate and reuse the logic behind each card.