coding-with-query-engine

What problem does it solve?

This Skill simplifies the process of building and troubleshooting Mu2e Query Engine (QE) URLs for accessing PostgreSQL-backed data, enabling efficient data retrieval in Python and C++.

Core Features & Use Cases

• QE URL Construction: Guides users in composing valid Query Engine URLs with various parameters like database, table, columns, filters, and sorting.
• Python HTTP Reads: Provides patterns for fetching data from QE endpoints using Python's urllib.
• C++ Database Fetches: Demonstrates how to use Mu2e's DbService wrappers (DbReader, DbIdList) for C++ applications.
• Use Case: Retrieve specific run information from the run_info database by constructing a QE URL with appropriate filters and then fetching the data using a Python script.

Quick Start

Use the coding-with-query-engine skill to build a QE URL to fetch the 'name' and 'version' columns from the 'app.versions' table in the 'mu2e_conditions_prd' database.