Overview

The SQL API provides programmatic access to Lunar's data through SQL queries. Through this interface, you can access and analyze information about your components, domains, policies, and more.

Accessing the SQL API

To access the SQL API, use the Lunar CLI command lunar sql connection-string to get a PostgreSQL connection string that can be used with any PostgreSQL client:

# Get the connection string
lunar sql connection-string

# Connect using psql (interactive)
psql $(lunar sql connection-string)

# Execute a query directly
psql $(lunar sql connection-string) -c "SELECT * FROM components LIMIT 5"

The access is read-only and restricted to only the views described in this documentation.

Available Views

For detailed information about available views, explore these pages:

• domains

• components

• component_deltas

• initiatives

• policies

• checks

• prs

• catalog

AI Skill

An AI skill is available to help you craft SQL queries against the Lunar data model. The lunar-sql skill provides your AI assistant with knowledge of the view schemas, JSONB query patterns, and common query examples.

See Installing AI Skills for setup instructions.