技能檔案

Db Inspect

Name: Db Inspect
Author: jhd3197

Inspect the ServerKit SQLite database — show tables, schemas, row counts, and run queries. Runs via WSL for local dev or SSH MCP for production. Use when debugging data issues or understanding the current database state.

jhd3197287 星標2026年3月3日

職業
分類: SQL 數據庫

技能內容

Inspect the ServerKit database. Argument: $ARGUMENTS

Database Location

Local dev: backend/instance/serverkit.db (relative to project root)
Production: /opt/serverkit/backend/instance/serverkit.db (access via SSH MCP)

If no argument or argument is "schema"

Show the full database schema:

sqlite3 backend/instance/serverkit.db '.schema'

And row counts for all tables:

sqlite3 backend/instance/serverkit.db "SELECT name FROM sqlite_master WHERE type='table' ORDER BY name;"

Then for each table, get the row count and present as a formatted table: Table Name | Row Count

If argument is a table name

相關技能

Db Inspect | Skills Pool

sqlite3 -header -column backend/instance/serverkit.db 'PRAGMA table_info(<table>);'
sqlite3 -header -column backend/instance/serverkit.db 'SELECT * FROM <table> ORDER BY id DESC LIMIT 10;'

sqlite3 -header -column backend/instance/serverkit.db '<query>'

Db Inspect

Database Location

If no argument or argument is "schema"

If argument is a table name

Db Inspect

Database Location

If no argument or argument is "schema"

If argument is a table name

If argument looks like a SQL query

If argument is "production" or "prod"

Safety

Postgres Patterns

Postgres Patterns

Database Migrations

Postgres Patterns

Postgres Patterns

Jpa Patterns