Sqlite

🌐Community
by g1joshi · vlatest · Repository

Query and analyze SQLite databases using natural language; extract data and generate reports directly from your data.

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 g1joshi-sqlite npx -- -y @trustedskills/g1joshi-sqlite
2

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

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

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

About This Skill

What it does

This skill allows AI agents to interact with SQLite databases. It can execute SQL queries, retrieve data, and perform basic database operations directly within the agent's workflow. The skill provides a structured way for agents to manage and utilize relational data.

When to use it

  • Data Analysis: An agent needs to analyze sales figures stored in an SQLite database to identify trends.
  • Inventory Management: An agent is tasked with updating product quantities in an inventory database based on new orders.
  • Report Generation: The agent must generate a report summarizing customer data from an existing SQLite database.
  • Configuration Storage: An agent needs to read and write configuration settings stored within an SQLite file.

Key capabilities

  • Execute SQL queries (SELECT, INSERT, UPDATE, DELETE)
  • Retrieve data from tables
  • Interact with SQLite databases

Example prompts

  • "Run a SELECT query on the 'customers' table to find all customers in California."
  • "Insert a new record into the 'orders' table with these details: [order details]."
  • “Update the price of product ID 123 in the ‘products’ table.”

Tips & gotchas

  • The agent needs access to the SQLite database file. Ensure proper permissions are configured.
  • Be mindful of SQL injection vulnerabilities when constructing queries from user input.

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
g1joshi
Installs
3

🌐 Community

Passed automated security scans.