Token导航 LogoToken导航

Agent Skill · 研究检索

sqlite-with-gcov(sqlite 与 gcov)

用于辅助数据库表结构、查询语句、迁移脚本和数据维护任务。它适合让 Agent 分析 schema、编写 SQL、排查查询问题、整理索引或生成迁移建议。使用时需要明确数据库类型、连接环境和目标表,区分只读分析与写入变更;涉及删除、更新、迁移和批量导入时,应优先 dry-run、备份或事务保护,避免误操作。

sqlite-with-gcov 是研究检索类 Agent Skill,可用宿主为 Codex、Claude、Cursor、Gemini CLI,通过GitHub 仓库获取,权限为接触敏感数据;许可证为 MIT,第三方扫描已通过,按安装量在研究检索类的 73,675 个 Skill 里排第 46,825。

总安装 760周安装 32GitHub Stars 93下载 266核验 2026-05-01

安装说明

本站只整理中文说明,不托管安装包,也不代用户安装。
GitHub
许可证
MIT

安装方式

通过对话安装

复制提示词发给支持本地命令或 Skills 的 AI 助手,先确认命令和权限,再让它执行。

请帮我安装这个 Agent Skill:sqlite-with-gcov(sqlite 与 gcov)
来源仓库:https://github.com/letta-ai/skills
仓库路径:skills/sqlite-with-gcov
安装命令:
npx skills add https://github.com/letta-ai/skills --skill sqlite-with-gcov
安装前请先检查当前环境是否支持对应 CLI,并向我确认将要执行的命令、安装目录、联网范围和文件读写权限;确认后再执行。

命令行安装

复制命令到本机终端执行。不同来源提供的安装方式可能略有差异;本站展示可直接复制的安装命令,安装前请核对来源页面。

skills.shnpx skills
npx skills add https://github.com/letta-ai/skills --skill sqlite-with-gcov

这个 Skill 是做什么的

研究检索类 Skill 主要解决「找资料、核对事实、把来源整理清楚」的问题,通常会让助手先检索再总结。

用于结合 gcov 覆盖率数据的 SQLite 数据库分析。适合在测试阶段追踪代码执行路径与数据关联。适用宿主包括 Codex、Claude、Cursor、Gemini CLI,接入前应确认版本、权限和运行环境要求。需同时提供数据库文件和覆盖率报告才能使用。主要用于调试和测试优化,不应用于生产环境。

sqlite-with-gcov 属于研究检索类 Skill,可作为该场景下的辅助能力补充。

来源仓库内路径:skills/sqlite-with-gcov

上手步骤

4 步
  1. 1

    确认自己的宿主工具

    公开资料标注支持 Codex、Claude、Cursor、Gemini CLI;先确认自己用的是其中之一,再按对应工具的 Skills 目录放置。

  2. 2

    拿到安装命令

    可以直接复制的命令是 npx skills add https://github.com/letta-ai/skills --skill sqlite-with-gcov;命令里的占位符换成自己的路径或密钥再执行。

  3. 3

    安装后重启宿主

    命令执行完要完全退出宿主工具再打开,让新装的 Skill 被重新扫描到,否则列表里可能看不到。

  4. 4

    按最小权限试用

    它需要接触敏感数据,先在测试目录或测试账号里跑,确认没问题再放到正式项目。

常见问题

6 条

sqlite-with-gcov 怎么安装?

在终端执行 npx skills add https://github.com/letta-ai/skills --skill sqlite-with-gcov。装完完全退出宿主工具再打开,让它重新扫描本地 Skill。

sqlite-with-gcov 支持哪些 AI 工具?

公开资料标注支持 Codex、Claude、Cursor、Gemini CLI。其他工具只要能读取本地 Skill 目录,一般也能手动放进去,但要自己确认触发方式是否一致。

sqlite-with-gcov 需要什么权限?

权限级别是接触敏感数据。该 Skill 可能接触密钥、Token、环境变量或敏感配置,应进入高风险复核队列,默认不自动发布。

sqlite-with-gcov 是免费的吗?

来源标注的许可证是 MIT。本站不代收任何费用,也不托管安装包;能否商用、要不要署名,以许可证原文为准。

sqlite-with-gcov 用的人多吗?

公开数据是累计安装 760 次,近一周安装 32 次,下载 266 次,GitHub 93 星。这些数字来自第三方目录统计,只能当作热度参考,不代表质量或安全性。

sqlite-with-gcov 安全吗?

第三方扫描结果为通过,但这只覆盖已知的静态检查项,不能替代自己读一遍源码和安装命令。

值得选的地方和要先想清楚的地方

值得选的地方

  • 同时适配 4 种工具,换客户端不用重新找替代品。
  • 3 个目录同时收录,说明这个 Skill 流传比较广。
  • 许可证明确为 MIT,商用和分发边界好判断。
  • 第三方扫描已通过,常见的高风险行为没有命中。

先想清楚的地方

  • 需要接触敏感数据,装到常用环境前要先评估影响面。
  • 第三方目录整理,版本更新和行为细节以来源仓库为准。

适不适合你

更适合

  • 已经在用 Codex,想直接扩展它能力的人。
  • 需要处理研究检索类任务、又不想每次都手写提示词的人。
  • 需要许可证清楚、并且有第三方扫描结果的团队项目。

不太适合

  • 环境里有大量密钥、凭证,不方便给第三方 Skill 读取的人。
  • 需要厂商级技术支持和 SLA 的生产系统。

研究检索类 Skill 对比

6 个同类
Skill总安装GitHub 星权限许可证扫描
find-skills

寻找技能 · Codex、Claude

31,199,81316,486操作浏览器MIT有提醒
self-improving-agent

自我改进 Agent · OpenClaw

16,464,0023,396接触敏感数据MIT-0通过
soultrace

灵魂追踪 · Codex、Claude

7,588,94412需要联网未明确有提醒
self-improving

自我完善 · OpenClaw

6,829,2841,046需要联网MIT-0通过
microsoft-foundry

微软代工厂 · Codex、Claude

6,614,144764调用外部服务未明确有提醒
sqlite-with-gcov

sqlite 与 gcov · 本页

76093接触敏感数据MIT通过

按安装量取同分类前几名;数字来自第三方目录统计,只作热度参考,不代表质量结论。

SKILL.md 原文

SQLite with gcov Code Coverage

This skill provides guidance for compiling SQLite or similar C/C++ projects with gcov instrumentation for code coverage analysis.

Core Concepts

How gcov Works

gcov generates two types of files:

  • .gcno files: Generated at compile time, contain control flow graph information
  • .gcda files: Generated at runtime, contain execution counts

Critical understanding: gcov embeds absolute paths at compile time. The .gcda files are written to paths based on where the source was compiled, NOT where the binary is installed or executed from.

Path Mechanics

When compiling with -fprofile-arcs -ftest-coverage (or --coverage):

  1. The compiler records the absolute path of each source file
  2. At runtime, .gcda files are written relative to these embedded paths
  3. Moving or installing the binary does NOT change where coverage data is written

Approach Strategies

Strategy 1: Build in the Final Location

Build directly in the directory where coverage files should be generated:

# If coverage files need to be in /app/sqlite
cd /app/sqlite
tar -xzf sqlite-source.tar.gz --strip-components=1
./configure CFLAGS="-fprofile-arcs -ftest-coverage" LDFLAGS="-lgcov"
make

This ensures .gcno and .gcda files are generated in /app/sqlite.

Strategy 2: Use GCOV_PREFIX Environment Variables

Redirect coverage data output at runtime:

# Set prefix to redirect .gcda files
export GCOV_PREFIX=/app/sqlite
export GCOV_PREFIX_STRIP=3  # Strip N leading path components

# Run the instrumented binary
./sqlite3

GCOV_PREFIX_STRIP removes leading directory components from the embedded path before prepending GCOV_PREFIX.

Strategy 3: Symbolic Links

Create symbolic links from the build directory to the expected location:

ln -s /tmp/build-dir/sqlite /app/sqlite

Step-by-Step Workflow

  1. Determine where coverage files must be generated

- Check test requirements or documentation - Identify expected .gcda file locations

  1. Choose a build strategy based on requirements:

- Build-in-place for simplest setup - GCOV_PREFIX for installed binaries - Symbolic links for flexible redirection

  1. Configure and compile with coverage flags ./configure CFLAGS="-fprofile-arcs -ftest-coverage -g -O0" \ LDFLAGS="-lgcov --coverage" make Alternatively, use the shorthand: ./configure CFLAGS="--coverage" LDFLAGS="--coverage"
  2. Verify compilation artifacts

- Check for .gcno files in the build directory - Verify gcov symbols in binary: nm binary | grep gcov

  1. Perform runtime verification (critical step)

- Execute the instrumented binary - Check for .gcda file generation in the expected location - If files appear elsewhere, adjust strategy

  1. Install if needed (after verifying coverage works)

Verification Checklist

Compile-Time Verification

  • .gcno files exist in build directory
  • Binary contains gcov symbols (nm <binary> | grep gcov)
  • No compilation errors related to coverage flags

Runtime Verification (Critical)

  • Run the instrumented binary with a simple command
  • Locate where .gcda files are generated
  • Confirm .gcda files appear in the expected location
  • If location is wrong, adjust build strategy before proceeding

Post-Installation Verification

  • Installed binary still generates coverage data
  • Coverage data is accessible for analysis
  • gcov can process the .gcno and .gcda files together

Common Pitfalls

1. Embedded Path Mismatch

Problem: Building in /tmp/build then installing to /app/sqlite - coverage data still writes to /tmp/build.

Solution: Build in the final location OR use GCOV_PREFIX environment variables.

2. Temporary Build Directory

Problem: Building in /tmp/ which may be cleaned up, losing .gcno files needed for coverage analysis.

Solution: Build in a persistent directory or copy .gcno files to a permanent location.

3. Incomplete Verification

Problem: Verifying only compilation (checking .gcno files exist) without testing runtime behavior.

Solution: Always run the binary and verify .gcda files are generated in the correct location before declaring success.

4. Missing gcno Files

Problem: .gcda files exist but gcov cannot analyze them without corresponding .gcno files.

Solution: Keep .gcno files accessible. They must be in the same directory structure as .gcda files for analysis.

5. PATH Configuration

Problem: Adding to ~/.bashrc doesn't affect all execution contexts.

Solution: Set PATH in the same shell session or use absolute paths. For persistent configuration, verify it applies to the test environment.

6. Optimization Interference

Problem: High optimization levels (-O2, -O3) can cause inaccurate coverage due to inlining and code reorganization.

Solution: Use -O0 or -Og with coverage builds for accurate results.

Debugging Coverage Issues

If .gcda files are not appearing where expected:

  1. Find where they ARE being generated: find / -name "*.gcda" 2>/dev/null
  2. Check embedded paths in the binary: strings <binary> | grep -E "\.gcda|\.gcno"
  3. Verify gcov runtime is linked: ldd <binary> | grep gcov
  4. Check for write permission issues: # Ensure the target directory is writable touch /expected/path/test.gcda && rm /expected/path/test.gcda

Environment Variables Reference

VariablePurpose
GCOV_PREFIXPrepend this path to all coverage file output
GCOV_PREFIX_STRIPRemove N leading path components before applying prefix
GCOV_ERROR_FILERedirect gcov error messages to a file

Key Principles

  1. Understand path embedding: gcov paths are set at compile time, not runtime
  2. Verify runtime behavior: Compilation success does not guarantee correct coverage setup
  3. Test before declaring done: Run the binary and check .gcda file locations
  4. Keep artifacts together: .gcno and .gcda files must be accessible for analysis
  5. Use persistent directories: Avoid /tmp/ for builds when coverage data must persist

平台分布

Claude Code

31.23%
按下载量换算83

Gemini CLI

21.85%
按下载量换算58

Antigravity

16.75%
按下载量换算45

windsurf

11.63%
按下载量换算31

OpenCode

7.48%
按下载量换算20

Codex

3.74%
按下载量换算10

安全审计

Gen Agent Trust Hub

通过

Socket

通过

Snyk

通过

权限和风险

接触敏感数据

该 Skill 可能接触密钥、Token、环境变量或敏感配置,应进入高风险复核队列,默认不自动发布。

安装前确认

本站仅展示第三方公开信息,不托管安装包,不提供自动安装或运行环境。安装前应自行审查源码、依赖和命令行为。

继续浏览同类 Skills