Query the Lunar SQL API using standard SQL syntax for engineering data analysis.
npx skills add https://github.com/earthly/skills --skill lunar-sql
Please help me install this Agent Skill. Skill: lunar-sql Source: https://github.com/earthly/skills/tree/main/skills/lunar-sql Command: npx skills add https://github.com/earthly/skills --skill lunar-sql
This Skill allows you to query Lunar's rich engineering data directly using SQL, enabling powerful analysis of your software development lifecycle without needing to write complex scripts.
checks and components tables, filters by status and date, and returns the relevant component IDs.Use the lunar-sql skill to get the connection string for the Lunar SQL API.
High-intent search queries and answers about installing and using this skill.
You can query engineering metrics for SDLC data analysis by running standard SQL queries against the Lunar PostgreSQL API to retrieve data on components, checks, policies, domains, and PRs. This allows direct analysis of software development lifecycle trends.
Available engineering data views include components, checks, policies, domains, and PRs. Querying these views with SQL allows you to analyze engineering standards, track component health over time, and identify compliance trends in your codebase.
To get the connection string for the Lunar SQL API, you use the lunar-sql skill. Once retrieved, you can use this connection string to connect your SQL client and begin querying the available engineering data views directly.
Yes, you need an understanding of standard SQL syntax and the Lunar data model to analyze SDLC metrics. This approach requires writing SQL queries to join tables, filter by status and date, and retrieve specific engineering insights.
Yes, you can find components that failed a security check by writing a SQL query that joins the checks and components tables, filters by status and date, and returns the relevant component IDs for your engineering data analysis.
Limitations include the requirement to understand both standard SQL syntax and the specific Lunar data model. Without knowledge of the available views and table relationships, you cannot effectively query for SDLC metrics or compliance data.
shelbeelyConfigure Prisma ORM with database providers and driver adapters.
Dev-Dennis-040Analyze raw data and generate business insights with dashboards and reports.
farmountainAutomate compliance verification and regulatory adherence monitoring across the SDLC.
LopeWaleCompute PM statistics from decisions and ops data using Bash/RG queries.