MCPVault

query

MCP tool from MCP Sqlite by jparkerweb

Execute a custom SQL query against the connected SQLite database.

How to use it

query is exposed by the MCP Sqlite MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the query tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

FULL MCP SQLITE LISTING

Other tools in MCP Sqlite (15)

conditions

(object, optional): Filter conditions as key-value pairs

create_record

Insert a new record into a table.

data

(object): Record data as key-value pairs

db_info

Get detailed information about the connected database.

delete_records

Delete records from a table that match specified conditions.

get_table_schema

Get detailed information about a table's schema.

limit

(number, optional): Maximum number of records to return

list_tables

List all tables in the database.

offset

(number, optional): Number of records to skip

read_records

Query records from a table with optional filtering.

sql

(string): The SQL query to execute

table

(string): Name of the table

tableName

(string): Name of the table

update_records

Update records in a table that match specified conditions.

values

(array, optional): Array of parameter values to use in the query