Sqlite Database Expert

🌐Community
by futuregerald Β· vlatest Β· Repository

Helps with SQLite, database as part of working with databases and data persistence workflows.

Install on your platform

We auto-selected Claude Code based on this skill’s supported platforms.

1

Run in terminal (recommended)

terminal
claude mcp add futuregerald-sqlite-database-expert npx -- -y @trustedskills/futuregerald-sqlite-database-expert
2

Or manually add to ~/.claude/settings.json

~/.claude/settings.json
{
  "mcpServers": {
    "futuregerald-sqlite-database-expert": {
      "command": "npx",
      "args": [
        "-y",
        "@trustedskills/futuregerald-sqlite-database-expert"
      ]
    }
  }
}

Requires Claude Code (claude CLI). Run claude --version to verify your install.

About This Skill

What it does

This skill allows you to interact with and manipulate SQLite databases. It can execute SQL queries, create tables, insert data, and retrieve information from existing databases. The agent will interpret your requests and translate them into appropriate SQL commands for efficient database management.

When to use it

  • You need to query a local database of customer orders to find specific items.
  • You want to analyze sales data stored in an SQLite file to identify trends.
  • You're building a small application that requires persistent storage using a lightweight database.
  • You need to create and populate a simple database for tracking personal finances.

Key capabilities

  • Execute SQL queries (SELECT, INSERT, UPDATE, DELETE)
  • Create new tables with specified schema
  • Retrieve data from existing databases
  • Manage database connections

Example prompts

  • "Show me all customers who placed an order in the last month."
  • "Create a table called 'products' with columns for id, name, and price."
  • "Insert a new product into the products table: name = 'Laptop', price = 1200."
  • β€œWhat is the average order value?”

Tips & gotchas

The agent requires access to the SQLite database file. Ensure the path to the database is provided correctly in your prompts for accurate results.

Tags

πŸ›‘οΈ

TrustedSkills Verification

Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates β€” what you install today is exactly what was reviewed and verified.

Security Audits

Gen Agent Trust HubPass
SocketPass
SnykPass

Details

Version
vlatest
License
Author
futuregerald
Installs
3

🌐 Community

Passed automated security scans.