Can I execute raw SQL queries?

Yes, the server exposes a 'query' tool to run custom SQL statements with optional parameter values.

What CRUD operations are supported?

You can create, read, update, and delete records using the respective tools with table names and data or conditions.

How do I get information about tables and schemas?

The server provides tools to list all tables and retrieve detailed schema information for any table.

Is authentication required to use this server?

No authentication or API keys are required; access is controlled by the local SQLite database file permissions.

MCP Sqlite

sqlitedatabasecrudsqlmcp

MCP server enabling full SQLite database CRUD, introspection, and custom SQL query execution.

Quick Install

Automated & IDE Setup

Copy the AI prompt to install this server into Claude Code, Cursor, or another agent — or use 1-click editor setup below.

Add to Cursor Add to VS Code

Not yet automatically verified

We haven't yet run this listing's install command through our automated sandbox check. This isn't a red flag — we're steadily working through the catalog.

Manual Client & Custom JSON ConfigExpand JSON ▾

Client Config & Setup

Choose your client or environment

Target File:~/Library/Application Support/Claude/claude_desktop_config.json

claude_desktop_config.json

{
  "mcpServers": {
    "jparkerweb-mcp-sqlite": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-sqlite",
        "<path-to-your-sqlite-database.db>"
      ]
    }
  }
}

💡 Paste the JSON block into your client's configuration file under mcpServers, then restart the application.

Overview

This MCP server provides comprehensive interaction with SQLite databases, supporting complete CRUD operations, database schema exploration, and execution of custom SQL queries. It is suitable for developers needing programmatic access to SQLite databases within an MCP-compatible AI agent environment. The server requires the path to the SQLite database file as a startup argument.

Use cases

Create, read, update, and delete records in SQLite tables

Explore database schema and list tables

Execute custom SQL queries with parameters

Integrate SQLite database access into AI agents using MCP

Key features

Complete CRUD operations on SQLite tables

Database introspection and schema retrieval

Custom SQL query execution with parameter binding

Supports query filtering with conditions, limits, and offsets

Capabilities & Tool Schemas (8)Self-reported

Inspect callable tools, capabilities, and parameters exposed to AI agents by MCP Sqlite.

tableName

Callable MCP tool function

table

Callable MCP tool function

data

Callable MCP tool function

conditions

Callable MCP tool function

limit

Callable MCP tool function

offset

Callable MCP tool function

Documentation Overview

🐇 MCP SQLite Server

This is a Model Context Protocol (MCP) server that provides comprehensive SQLite database interaction capabilities.

cursor-settings

Maintained by

Features

Complete CRUD operations (Create, Read, Update, Delete)
Database exploration and introspection
Execute custom SQL queries

Setup

Define the command in your IDE's MCP Server settings:

e.g. Cursor:

config.json

{

    "mcpServers": {

        "MCP SQLite Server": {

            "command": "npx",

            "args": [

                "-y",

                "mcp-sqlite",

                "<path-to-your-sqlite-database.db>"

            ]

        }

    }

}

e.g. VSCode:

config.json

{

    "servers": {

        "MCP SQLite Server": {

            "type": "stdio",

            "command": "npx",

            "args": [

                "-y",

                "mcp-sqlite",

                "<path-to-your-sqlite-database.db>"

            ]

        }

    }

}

cursor-settings

Your database path must be provided as an argument.

Available Tools

Database Information

db_info

Get detailed information about the connected database.

Example:

config.json

{

  "method": "tools/call",

  "params": {

    "name": "db_info",

    "arguments": {}

  }

}

list_tables

List all tables in the database.

Example:

config.json

{

  "method": "tools/call",

  "params": {

    "name": "list_tables",

    "arguments": {}

  }

}

get_table_schema

Get detailed information about a table's schema.

Parameters:

tableName (string): Name of the table

Example:

config.json

{

  "method": "tools/call",

  "params": {

    "name": "get_table_schema",

    "arguments": {

      "tableName": "users"

    }

  }

}

CRUD Operations

create_record

Insert a new record into a table.

Parameters:

table (string): Name of the table
data (object): Record data as key-value pairs

Example:

config.json

{

  "method": "tools/call",

  "params": {

    "name": "create_record",

    "arguments": {

      "table": "users",

      "data": {

        "name": "John Doe",

        "email": "john@example.com",

        "age": 30

      }

    }

  }

}

read_records

Query records from a table with optional filtering.

Parameters:

table (string): Name of the table
conditions (object, optional): Filter conditions as key-value pairs
limit (number, optional): Maximum number of records to return
offset (number, optional): Number of records to skip

Example:

config.json

{

  "method": "tools/call",

  "params": {

    "name": "read_records",

    "arguments": {

      "table": "users",

      "conditions": {

        "age": 30

      },

      "limit": 10,

      "offset": 0

    }

  }

}

update_records

Update records in a table that match specified conditions.

Parameters:

table (string): Name of the table
data (object): New values as key-value pairs
conditions (object): Filter conditions as key-value pairs

Example:

config.json

{

  "method": "tools/call",

  "params": {

    "name": "update_records",

    "arguments": {

      "table": "users",

      "data": {

        "email": "john.updated@example.com"

      },

      "conditions": {

        "id": 1

      }

    }

  }

}

delete_records

Delete records from a table that match specified conditions.

Parameters:

table (string): Name of the table
conditions (object): Filter conditions as key-value pairs

Example:

config.json

{

  "method": "tools/call",

  "params": {

    "name": "delete_records",

    "arguments": {

      "table": "users",

      "conditions": {

        "id": 1

      }

    }

  }

}

Custom Queries

query

Execute a custom SQL query against the connected SQLite database.

Parameters:

sql (string): The SQL query to execute
values (array, optional): Array of parameter values to use in the query

Example:

config.json

{

  "method": "tools/call",

  "params": {

    "name": "query",

    "arguments": {

      "sql": "SELECT * FROM users WHERE id = ?",

      "values": [1]

    }

  }

}

Built with

Appreciation

If you enjoy this library please consider sending me a tip to support my work 😀

🍵 tip me here

Read the full README →View source on GitHub →

Related MCP Servers

View all in Databases View all alternatives

Adoption & maintenance

Factual signals from GitHub, npm, and our automated checks — not a rating.

GitHub stars

127

Stargazers on the source repository.

Last commit

5mo ago

Most recent push to the default branch.

Tools exposed

Callable tools this server registers over MCP.

Directory activity

2 views

Config copies, upvotes, and views on AllMCPs.

Reviews

No reviews yet — be the first to share how this listing worked for you.

Frequently Asked Questions about MCP Sqlite

You provide the path to your SQLite database file as a command-line argument when starting the server.

AllMCPs Directory Badge

Full Badge Customizer

Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.

Badge Style:

Live Dynamic SVG Preview

Markdown (GitHub README)

[![AllMCPs](https://allmcps.com/api/badge/jparkerweb-mcp-sqlite?style=directory)](https://allmcps.com/mcp/jparkerweb-mcp-sqlite)

HTML Embed

<a href="https://allmcps.com/mcp/jparkerweb-mcp-sqlite"><img src="https://allmcps.com/api/badge/jparkerweb-mcp-sqlite?style=directory" alt="MCP Sqlite on AllMCPs" /></a>

Technical Specs & Signals

CategoryDatabases

PricingFree

10/10 checks healthy over the last 31d

56Quality signal: Good · 56/100How this signal is calculated ▾

Server availabilityNot measured

Not scored for repo-hosted servers — we can't reach the running server, only its GitHub page. Hosted MCP endpoints are health-checked live.

Verified ownership10/20

Documentation & tools27/30

Adoption & activity5/15

Community engagement0/10

A guidance signal from public completeness & health data — not a user rating. New listings start lower and rise as they add docs, get verified, and grow adoption. Signals we can't observe for a listing are skipped, not counted against it.

Supply-chain signal

No high-severity advisories surfaced by our automated scan.

Critical 0High 0Medium 0Low 0

Scanned 23d ago via OSV.dev · <path-to-your-sqlite-database.db> (npm)

★ Featured

AllMCPs Server

The official MCP server for AllMCPs.com - submit and manage tools directly from your AI. The open directory for MCP servers. Connect Claude, Cursor, Windsurf, and AI agents to databases, tools, files, and APIs. Explore 10,000+ servers. AllMCPs is the premier, open directory for discovering, evaluating, and installing Model Context Protocol (MCP) servers to equip AI agents and LLMs with real-world superpowers.

Explore Server →

Own this project?

This directory is pre-filled from public sources. Claim via GitHub README, site badge, or DNS TXT to unlock edit access and the Official badge — proof is checked automatically, then reviewed by our team.

Free dofollow backlink: add your website and place the AllMCPs badge on it — no claim needed. We detect it automatically and keep it verified as long as the badge stays live.

Claim & get free dofollow

Share & Embed

Add our SVG badge (dark/light directory styles) or embeddable widget to your site.

Explore more

More in 🗄️ Databases →Best MCP servers for Databases →Alternatives to MCP Sqlite →Install in Claude Desktop Install in Cursor Install in VS Code

MCP Sqlite

sqlitedatabasecrudsqlmcp

MCP server enabling full SQLite database CRUD, introspection, and custom SQL query execution.

Quick Install

Automated & IDE Setup

Copy the AI prompt to install this server into Claude Code, Cursor, or another agent — or use 1-click editor setup below.

Add to Cursor Add to VS Code

Not yet automatically verified

We haven't yet run this listing's install command through our automated sandbox check. This isn't a red flag — we're steadily working through the catalog.

Manual Client & Custom JSON ConfigExpand JSON ▾

Client Config & Setup

Choose your client or environment

Target File:~/Library/Application Support/Claude/claude_desktop_config.json

claude_desktop_config.json

{
  "mcpServers": {
    "jparkerweb-mcp-sqlite": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-sqlite",
        "<path-to-your-sqlite-database.db>"
      ]
    }
  }
}

💡 Paste the JSON block into your client's configuration file under mcpServers, then restart the application.

Overview

Use cases

Create, read, update, and delete records in SQLite tables

Explore database schema and list tables

Execute custom SQL queries with parameters

Integrate SQLite database access into AI agents using MCP

Key features

Complete CRUD operations on SQLite tables

Database introspection and schema retrieval

Custom SQL query execution with parameter binding

Supports query filtering with conditions, limits, and offsets

Capabilities & Tool Schemas (8)Self-reported

Inspect callable tools, capabilities, and parameters exposed to AI agents by MCP Sqlite.

tableName

Callable MCP tool function

table

Callable MCP tool function

data

Callable MCP tool function

conditions

Callable MCP tool function

limit

Callable MCP tool function

offset

Callable MCP tool function

Documentation Overview

🐇 MCP SQLite Server

This is a Model Context Protocol (MCP) server that provides comprehensive SQLite database interaction capabilities.

cursor-settings

Maintained by

Features

Complete CRUD operations (Create, Read, Update, Delete)
Database exploration and introspection
Execute custom SQL queries

Setup

Define the command in your IDE's MCP Server settings:

e.g. Cursor:

config.json

{

    "mcpServers": {

        "MCP SQLite Server": {

            "command": "npx",

            "args": [

                "-y",

                "mcp-sqlite",

                "<path-to-your-sqlite-database.db>"

            ]

        }

    }

}

e.g. VSCode:

config.json

{

    "servers": {

        "MCP SQLite Server": {

            "type": "stdio",

            "command": "npx",

            "args": [

                "-y",

                "mcp-sqlite",

                "<path-to-your-sqlite-database.db>"

            ]

        }

    }

}

cursor-settings

Your database path must be provided as an argument.

Available Tools

Database Information

db_info

Get detailed information about the connected database.

Example:

config.json

{

  "method": "tools/call",

  "params": {

    "name": "db_info",

    "arguments": {}

  }

}

list_tables

List all tables in the database.

Example:

config.json

{

  "method": "tools/call",

  "params": {

    "name": "list_tables",

    "arguments": {}

  }

}

get_table_schema

Get detailed information about a table's schema.

Parameters:

tableName (string): Name of the table

Example:

config.json

{

  "method": "tools/call",

  "params": {

    "name": "get_table_schema",

    "arguments": {

      "tableName": "users"

    }

  }

}

CRUD Operations

create_record

Insert a new record into a table.

Parameters:

table (string): Name of the table
data (object): Record data as key-value pairs

Example:

config.json

{

  "method": "tools/call",

  "params": {

    "name": "create_record",

    "arguments": {

      "table": "users",

      "data": {

        "name": "John Doe",

        "email": "john@example.com",

        "age": 30

      }

    }

  }

}

read_records

Query records from a table with optional filtering.

Parameters:

table (string): Name of the table
conditions (object, optional): Filter conditions as key-value pairs
limit (number, optional): Maximum number of records to return
offset (number, optional): Number of records to skip

Example:

config.json

{

  "method": "tools/call",

  "params": {

    "name": "read_records",

    "arguments": {

      "table": "users",

      "conditions": {

        "age": 30

      },

      "limit": 10,

      "offset": 0

    }

  }

}

update_records

Update records in a table that match specified conditions.

Parameters:

table (string): Name of the table
data (object): New values as key-value pairs
conditions (object): Filter conditions as key-value pairs

Example:

config.json

{

  "method": "tools/call",

  "params": {

    "name": "update_records",

    "arguments": {

      "table": "users",

      "data": {

        "email": "john.updated@example.com"

      },

      "conditions": {

        "id": 1

      }

    }

  }

}

delete_records

Delete records from a table that match specified conditions.

Parameters:

table (string): Name of the table
conditions (object): Filter conditions as key-value pairs

Example:

config.json

{

  "method": "tools/call",

  "params": {

    "name": "delete_records",

    "arguments": {

      "table": "users",

      "conditions": {

        "id": 1

      }

    }

  }

}

Custom Queries

query

Execute a custom SQL query against the connected SQLite database.

Parameters:

sql (string): The SQL query to execute
values (array, optional): Array of parameter values to use in the query

Example:

config.json

{

  "method": "tools/call",

  "params": {

    "name": "query",

    "arguments": {

      "sql": "SELECT * FROM users WHERE id = ?",

      "values": [1]

    }

  }

}

Built with

Appreciation

If you enjoy this library please consider sending me a tip to support my work 😀

🍵 tip me here

Read the full README →View source on GitHub →

Related MCP Servers

View all in Databases View all alternatives

Adoption & maintenance

Factual signals from GitHub, npm, and our automated checks — not a rating.

GitHub stars

127

Stargazers on the source repository.

Last commit

5mo ago

Most recent push to the default branch.

Tools exposed

Callable tools this server registers over MCP.

Directory activity

2 views

Config copies, upvotes, and views on AllMCPs.

Reviews

No reviews yet — be the first to share how this listing worked for you.

Frequently Asked Questions about MCP Sqlite

You provide the path to your SQLite database file as a command-line argument when starting the server.

AllMCPs Directory Badge

Full Badge Customizer

Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.

Badge Style:

Live Dynamic SVG Preview

Markdown (GitHub README)

[![AllMCPs](https://allmcps.com/api/badge/jparkerweb-mcp-sqlite?style=directory)](https://allmcps.com/mcp/jparkerweb-mcp-sqlite)

HTML Embed

<a href="https://allmcps.com/mcp/jparkerweb-mcp-sqlite"><img src="https://allmcps.com/api/badge/jparkerweb-mcp-sqlite?style=directory" alt="MCP Sqlite on AllMCPs" /></a>

Technical Specs & Signals

CategoryDatabases

PricingFree

10/10 checks healthy over the last 31d

56Quality signal: Good · 56/100How this signal is calculated ▾

Server availabilityNot measured

Not scored for repo-hosted servers — we can't reach the running server, only its GitHub page. Hosted MCP endpoints are health-checked live.

Verified ownership10/20

Documentation & tools27/30

Adoption & activity5/15

Community engagement0/10

Supply-chain signal

No high-severity advisories surfaced by our automated scan.

Critical 0High 0Medium 0Low 0

Scanned 23d ago via OSV.dev · <path-to-your-sqlite-database.db> (npm)

★ Featured

AllMCPs Server

Explore Server →

Own this project?

Free dofollow backlink: add your website and place the AllMCPs badge on it — no claim needed. We detect it automatically and keep it verified as long as the badge stays live.

Claim & get free dofollow

Share & Embed

Add our SVG badge (dark/light directory styles) or embeddable widget to your site.

Explore more

More in 🗄️ Databases →Best MCP servers for Databases →Alternatives to MCP Sqlite →Install in Claude Desktop Install in Cursor Install in VS Code