Skip to content

Latest commit

 

History

History
84 lines (62 loc) · 1.93 KB

index.md

File metadata and controls

84 lines (62 loc) · 1.93 KB
Raw
organization category brand_color display_name short_name description og_description og_image icon_url
francois2metz
saas
#4052c7
Plausible
plausible
Steampipe plugin for querying statistics from Plausible.
Query Plausible with SQL! Open source CLI. No DB required.
/images/plugins/francois2metz/plausible-social-graphic.png
/images/plugins/francois2metz/plausible.svg

Plausible + Steampipe

Plausible is an analytics company.

Steampipe is an open source CLI to instantly query cloud APIs using SQL.

For example:

select
  time,
  visitors
from
  plausible_timeseries
where
  domain='example.net'
  and period='6mo'
  and interval='month'
+------------+----------+
| time       | visitors |
+------------+----------+
| 2022-04-01 | 453      |
| 2022-06-01 | 358      |
| 2022-07-01 | 556      |
| 2022-09-01 | 705      |
| 2022-05-01 | 488      |
| 2022-08-01 | 677      |
+------------+----------+

Documentation

Get started

Install

Download and install the latest Plausible plugin:

steampipe plugin install ghcr.io/francois2metz/plausible

Configuration

Installing the latest plausible plugin will create a config file (~/.steampipe/config/plausible.spc) with a single connection named plausible:

connection "francois2metz/plausible" {
  plugin = "ghcr.io/francois2metz/plausible"

  # Go to https://plausible.io/settings/api-keys/new
  # token = "IH-EtVQAtk7ytSQ1lDo46CFjXZmTJF0g8UpKP6wtq1PmnE1nKih-8XEf4iHsZU8W"

  # Base URL to the Plausible API when using a custom installation
  # base_url = ""
}

You can also use environment variables:

  • PLAUSIBLE_TOKEN: Your plausible API Key
  • PLAUSIBLE_BASE_URL: The plausible base API URL

Get Involved