Skip to content
Back to search

mcp-sqlite

πŸ‡ Model Context Protocol (MCP) server that provides comprehensive SQLite database interaction capabilities

Safety scan

A static text scan, not a guarantee. Select the badge to see what was scanned and every finding.

Checked today
Badge for your README
findsafeskills safety rating

Markdown

[![findsafeskills safety rating](/api/listings/jparkerweb--mcp-sqlite/badge.svg)](/listings/jparkerweb--mcp-sqlite)

HTML

<a href="/listings/jparkerweb--mcp-sqlite"><img src="/api/listings/jparkerweb--mcp-sqlite/badge.svg" alt="findsafeskills safety rating" /></a>

Install

i

Install instructions from the README

As written by the repo's author. findsafeskills has not verified these steps.

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

e.g. `Cursor`:

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

e.g. `VSCode`:

{
    "servers": {
        "MCP SQLite Server": {
            "type": "stdio",
            "command": "npx",
            "args": [
                "-y",
                "mcp-sqlite",
                "<path-to-your-sqlite-database.db>"
            ]
        }
    }
}

Your database path must be provided as an argument.

What was scanned

The files the safety scan read, as written by the repository's author and shown as plain text. Lines with a finding are marked.

README.md Β· README Β· 252 lines

View this file on GitHub (read at the repository's current version: the scan did not record which commit it read)

  1. # πŸ‡ MCP SQLite Server
  2. This is a Model Context Protocol (MCP) server that provides comprehensive SQLite database interaction capabilities.
  3. ![cursor-settings](https://raw.githubusercontent.com/jparkerweb/mcp-sqlite/refs/heads/main/.readme/mcp-sqlite.jpg)
  4. #### Maintained by
  5. <a href="https://www.equilllabs.com">
  6. <img src="https://raw.githubusercontent.com/jparkerweb/eQuill-Labs/refs/heads/main/src/static/images/logo-text-outline.png" alt="eQuill Labs" height="32">
  7. </a>
  8. ## Features
  9. - Complete CRUD operations (Create, Read, Update, Delete)
  10. - Database exploration and introspection
  11. - Execute custom SQL queries
  12. ## Setup
  13. Define the command in your IDE's MCP Server settings:
  14. e.g. `Cursor`:
  15. ```json
  16. {
  17. "mcpServers": {
  18. "MCP SQLite Server": {
  19. "command": "npx",
  20. "args": [
  21. "-y",
  22. "mcp-sqlite",
  23. "<path-to-your-sqlite-database.db>"
  24. ]
  25. }
  26. }
  27. }
  28. ```
  29. e.g. `VSCode`:
  30. ```json
  31. {
  32. "servers": {
  33. "MCP SQLite Server": {
  34. "type": "stdio",
  35. "command": "npx",
  36. "args": [
  37. "-y",
  38. "mcp-sqlite",
  39. "<path-to-your-sqlite-database.db>"
  40. ]
  41. }
  42. }
  43. }
  44. ```
  45. ![cursor-settings](https://raw.githubusercontent.com/jparkerweb/mcp-sqlite/refs/heads/main/.readme/cursor-mcp-settings.jpg)
  46. Your database path must be provided as an argument.
  47. ## Available Tools
  48. ### Database Information
  49. #### db_info
  50. Get detailed information about the connected database.
  51. Example:
  52. ```json
  53. {
  54. "method": "tools/call",
  55. "params": {
  56. "name": "db_info",
  57. "arguments": {}
  58. }
  59. }
  60. ```
  61. #### list_tables
  62. List all tables in the database.
  63. Example:
  64. ```json
  65. {
  66. "method": "tools/call",
  67. "params": {
  68. "name": "list_tables",
  69. "arguments": {}
  70. }
  71. }
  72. ```
  73. #### get_table_schema
  74. Get detailed information about a table's schema.
  75. Parameters:
  76. - `tableName` (string): Name of the table
  77. Example:
  78. ```json
  79. {
  80. "method": "tools/call",
  81. "params": {
  82. "name": "get_table_schema",
  83. "arguments": {
  84. "tableName": "users"
  85. }
  86. }
  87. }
  88. ```
  89. ### CRUD Operations
  90. #### create_record
  91. Insert a new record into a table.
  92. Parameters:
  93. - `table` (string): Name of the table
  94. - `data` (object): Record data as key-value pairs
  95. Example:
  96. ```json
  97. {
  98. "method": "tools/call",
  99. "params": {
  100. "name": "create_record",
  101. "arguments": {
  102. "table": "users",
  103. "data": {
  104. "name": "John Doe",
  105. "email": "john@example.com",
  106. "age": 30
  107. }
  108. }
  109. }
  110. }
  111. ```
  112. #### read_records
  113. Query records from a table with optional filtering.
  114. Parameters:
  115. - `table` (string): Name of the table
  116. - `conditions` (object, optional): Filter conditions as key-value pairs
  117. - `limit` (number, optional): Maximum number of records to return
  118. - `offset` (number, optional): Number of records to skip
  119. Example:
  120. ```json
  121. {
  122. "method": "tools/call",
  123. "params": {
  124. "name": "read_records",
  125. "arguments": {
  126. "table": "users",
  127. "conditions": {
  128. "age": 30
  129. },
  130. "limit": 10,
  131. "offset": 0
  132. }
  133. }
  134. }
  135. ```
  136. #### update_records
  137. Update records in a table that match specified conditions.
  138. Parameters:
  139. - `table` (string): Name of the table
  140. - `data` (object): New values as key-value pairs
  141. - `conditions` (object): Filter conditions as key-value pairs
  142. Example:
  143. ```json
  144. {
  145. "method": "tools/call",
  146. "params": {
  147. "name": "update_records",
  148. "arguments": {
  149. "table": "users",
  150. "data": {
  151. "email": "john.updated@example.com"
  152. },
  153. "conditions": {
  154. "id": 1
  155. }
  156. }
  157. }
  158. }
  159. ```
  160. #### delete_records
  161. Delete records from a table that match specified conditions.
  162. Parameters:
  163. - `table` (string): Name of the table
  164. - `conditions` (object): Filter conditions as key-value pairs
  165. Example:
  166. ```json
  167. {
  168. "method": "tools/call",
  169. "params": {
  170. "name": "delete_records",
  171. "arguments": {
  172. "table": "users",
  173. "conditions": {
  174. "id": 1
  175. }
  176. }
  177. }
  178. }
  179. ```
  180. ### Custom Queries
  181. #### query
  182. Execute a custom SQL query against the connected SQLite database.
  183. Parameters:
  184. - `sql` (string): The SQL query to execute
  185. - `values` (array, optional): Array of parameter values to use in the query
  186. Example:
  187. ```json
  188. {
  189. "method": "tools/call",
  190. "params": {
  191. "name": "query",
  192. "arguments": {
  193. "sql": "SELECT * FROM users WHERE id = ?",
  194. "values": [1]
  195. }
  196. }
  197. }
  198. ```
  199. ## Built with
  200. - [Model Context Protocol SDK](https://github.com/modelcontextprotocol/typescript-sdk)
  201. - [sqlite3](https://github.com/TryGhost/node-sqlite3)
  202. ---
  203. ## Appreciation
  204. If you enjoy this library please consider sending me a tip to support my work πŸ˜€
  205. ### [🍡 tip me here](https://ko-fi.com/jparkerweb)

Ratings and comments

Sign in to rate this skill.

Sign in

Free to use. If it’s helped, pass it on.