mcp-registry/mcp-sqlite

    ==================
      
       /// MCP ///
      /// MCP ///
        
    ==================
        
    [server:online]
    [protocol:ready]

mcp-sqlite

by jparkerweb

Model Context Protocol (MCP) server that provides comprehensive SQLite database interaction capabilities

23
2
Open Source
GitHubDocumentationNPM

01

db_info

Get detailed information about the connected database.

02

list_tables

List all tables in the database.

03

get_table_schema

Get detailed information about a table's schema.

04

create_record

Insert a new record into a table.

05

read_records

Query records from a table with optional filtering.

06

update_records

Update records in a table that match specified conditions.

07

delete_records

Delete records from a table that match specified conditions.

08

query

Execute a custom SQL query against the connected SQLite database.

Installation

1. Prerequisites:
• Node.js ≥ 18
• A writable SQLite database file (or the path where one should be created)
2. Add the package to your project:
# with npm
npm install mcp-sqlite --save
# or with yarn
yarn add mcp-sqlite
3. (Optional) Create a .env file to point the server at a specific database:
MCP_SQLITE_DB_PATH=./database.sqlite
4. Start the MCP server from the command line:
npx mcp-sqlite --port 3333 # default port 3333
5. Integrate with your MCP router / orchestrator by registering the server URL (e.g. http://localhost:3333) so that the tools declared below become available to your models.

Documentation

# Transform Augment Code into Your Database-Aware Coding Assistant

**The mcp-sqlite server turns Augment Code into a powerful database development companion that can directly interact with your SQLite databases, eliminating the constant context switching between your IDE and database tools.**

Instead of manually writing SQL queries, checking schemas, and validating data changes in separate tools, you can now ask Augment to "show me the users table structure," "find all orders from the last week," or "update the inventory counts based on these sales data" – and it will execute these operations directly against your SQLite database. This MCP server provides Augment with eight essential database tools: complete CRUD operations, schema inspection, table listing, and custom query execution.

## Supercharge Your Database Development Workflow

Add this server to your Augment Code configuration and watch your database development productivity soar:

```json
{
    "mcpServers": {
        "SQLite Database": {
            "command": "npx",
            "args": ["-y", "mcp-sqlite", "./your-database.db"]
        }
    }
}
```

**Real-world scenarios where this combination excels:**
- **API Development**: Ask Augment to "create a new user record with validation" and it will generate the code AND execute the database insert
- **Data Migration**: "Show me all tables and their relationships" - Augment can inspect your schema and help write migration scripts
- **Debugging**: "Find the last 10 transactions for user ID 123" - get instant query results without leaving your coding flow
- **Testing**: "Create test data for the products table" - Augment can generate realistic test records and insert them directly
- **Analytics**: "Get monthly sales totals grouped by category" - complex queries executed and results formatted for your code

This isn't just about database convenience – it's about maintaining coding flow. When Augment can directly access your database, it provides more accurate code suggestions, validates data operations in real-time, and helps you build data-driven applications without the mental overhead of managing database connections separately.
License: MIT License
Updated 7/15/2025

Table of Contents