Construct Mu2e Query Engine URLs for PostgreSQL data access.
npx skills add https://github.com/Mu2e/aitools --skill coding-with-query-engine
Please help me install this Agent Skill. Skill: coding-with-query-engine Source: https://github.com/Mu2e/aitools/tree/main/skills/coding-with-query-engine Command: npx skills add https://github.com/Mu2e/aitools --skill coding-with-query-engine
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++.
urllib.DbService wrappers (DbReader, DbIdList) for C++ applications.run_info database by constructing a QE URL with appropriate filters and then fetching the data using a Python script.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.
High-intent search queries and answers about installing and using this skill.
Query Engine URL construction involves specifying parameters like database, table, columns, filters, and sorting to access Mu2e PostgreSQL data. This format enables efficient data retrieval from Mu2e conditions and operations databases.
Fetching Mu2e database records in Python uses the urllib library to perform HTTP reads of constructed Query Engine URLs. This method retrieves specific run information and conditions data directly from PostgreSQL endpoints.
Yes, C++ can read Mu2e PostgreSQL data using Mu2e DbService wrappers like DbReader and DbIdList. These wrappers facilitate direct database fetches for C++ applications without needing HTTP URL construction.
Python HTTP reads use urllib to fetch data via Query Engine URLs, while C++ DbService uses DbReader wrappers for direct database access. The choice depends on your application's language and whether URL-based or direct database access is preferred.
Filtering specific run information from the run_info database requires constructing a Query Engine URL with appropriate filter parameters. This URL is then executed via a Python script to retrieve the targeted data.
Yes, the Mu2e Query Engine supports retrieving specific columns by constructing a URL that targets the app.versions table in the mu2e_conditions_prd database. You can specify desired columns like name and version directly in the URL parameters.
windyskyAutomate C# 12 and .NET 8 development patterns for ASP.NET Core apps.
stahuraExecute raw SQL queries against dataset aliases and parse columnar responses into row objects.
whatagraphManage reusable filter configurations for marketing data channels.
bouwerpExecute read-only SQL queries against configured PostgreSQL databases.