~/.steampipe/config/
├── default.spc          # 全局 options（database/general/plugin_manager）
├── hackernews.spc       # 插件安装时自动生成的默认连接文件
├── steampipe.spc        # 同上（steampipe 插件）
├── hn.spc               # 自建的命名连接 + 聚合连接
└── *.spc.sample         # 初始化生成的样例（default.spc.sample 等）

# Steampipe specific configuration
options "database" {
  # Sets the port that the database service listens on. Default 9193
  # port = 9193

  # Listen on localhost (local), tailnet (tailnet), any (network)
  # Default: network - use "local" to accept connections only from localhost
  # listen = "network"

  # Set to true to enable dashboard service
  # dashboard = false

  # Create a steampipe foreign table for each connection
  # Set to false to disable creation of the steampipe foreign table
  # foreign_tables_enabled = true

  # Enable TLS encryption
  # ssl = false

  # Set the database password - this must be a strong password
  # if not set, a random password will be generated
  # password = "mySuperSecretPassword"

  # Set the search path for the database - this is a comma separated list of
  # schemas to search for unqualified table names
  # search_path = ""

  # Enable query result caching
  # cache = true

  # Set the cache TTL for query results - defaults to 300 seconds
  # cache_max_ttl = 300

  # Set the shared_buffers for the database
  # shared_buffers = "64MB"

  # Set the effective_cache_size for the database
  # effective_cache_size = "512MB"

  # Set the work_mem for the database
  # work_mem = "4MB"

  # Set the minimum duration in milliseconds before a query is logged
  # log_min_duration = 1000

  # Enable logging of query stats
  # log_query_stats = true

  # Enable logging of database connections
  # log_connections = false

  # Enable logging of database disconnections
  # log_disconnections = false
}

options "general" {
  # log level - error, warn, info, debug, trace
  log_level = "info"

  # number of log files to keep
  log_max_backups = 30

  # maximum size of a log file in MB
  log_file_max_size_mb = 100

  # whether to log plugin stderr output
  log_plugin_stderr = false

  # timeout in seconds for plugin startup or queries (set to 0 to disable)
  plugin_timeout = 300
  query_timeout  = 300

  # enable update check (stable stream only)
  update_check = true

  # telemetry level - none, errors, standard, all
  telemetry = "standard"

  # index size in MB
  index_size = 128
}

options "plugin_manager" {
  # maximum number of concurrent plugin connections
  max_concurrency = 12
}

# v0.x 旧语法（已失效）
connection "hackernews" "hackernews" "hn" {
}

Error: Internal Error: Failed to load config: Extraneous label for connection:
Only 1 labels (name) are expected for connection blocks.
(/home/admin/.steampipe/config/hn.spc:1,1-30)

# ~/.steampipe/config/hn.spc
connection "hn" {
  plugin = "hackernews"
}

$ steampipe service restart
$ steampipe query "select count(*) as hn_top_stories from hn.hackernews_top;"
+----------------+
| hn_top_stories |
+----------------+
| 500            |
+----------------+

connection "hackernews" {
  plugin = "hackernews"

  # The maximum number of items to return for list and search queries.
  # max_items = 100
}

connection "hn_all" {
  plugin      = "hackernews"
  type        = "aggregator"
  connections = ["hn", "hackernews"]
}

+----------+
| agg_rows |
+----------+
| 1,000    |
+----------+

# workspace "profile_name" {
#   # database
#   database_listen      = "network"
#   database_port        = 9193
#   database_password    = "mySuperSecretPassword"
#   database_search_path = ""
#   database_ssl         = false
#   foreign_tables_enabled = true
#   dashboard            = false
#   dashboard_database   = 9193
#   dashboard_listen     = "network"
#   dashboard_port       = 9193
#   dashboard_watch      = false
#
#   # general
#   index_size     = 128
#   log_level      = "info"
#   plugin_timeout = 300
#   query_timeout  = 300
#   update_check   = true
#   telemetry      = "standard"
#
#   # plugin manager
#   plugin_manager_max_concurrency = 12
# }

~/.steampipe/internal/
├── connection.json   # 服务运行时的连接串（服务停止时为 {}）
├── .passwd           # 内嵌库随机口令（未显式设 password 时）
├── update_check.json # 版本检查缓存（实测含 current_version/latest_version）
└── versions.json     # 组件版本清单
~/.steampipe/logs/    # CLI/服务/插件日志（log_level=info 实测产出）

# default.spc
options "database" {
  listen   = "local"
  password = "q1w2e3r4"
}
options "general" {
  telemetry    = "none"
  update_check = false
}

ExecStart=/usr/local/bin/steampipe service start --foreground --database-listen local --database-password q1w2e3r4

connection "acct_prod" { plugin = "aws", profile = "prod" }
connection "acct_test" { plugin = "aws", profile = "test" }
connection "aws_all" {
  plugin      = "aws"
  type        = "aggregator"
  connections = ["acct_prod", "acct_test"]
}
# select * from aws_all.aws_s3_bucket