ToolBox MCP Server

by xiaoguomeiyitian
Verified

sqlite_tool

Execute SQLite database operations like query, transaction, backup, optimization, and indexing. Manage tables, check database integrity, and handle paginated queries for efficient data handling.

Input Schema

NameRequiredDescriptionDefault
actionYesOperation type
backupNameNoBackup file name (without extension)
dbNameYesDatabase file name (without extension)
indexNameNoIndex name
paginationNoPagination settings
paramsNoSQL query parameters
queryNoSQL query to execute
tableNameNoTable name

Input Schema (JSON Schema)

{ "description": "Perform SQLite database operations", "name": "sqlite_tool", "properties": { "action": { "description": "Operation type", "enum": [ "query", "transaction", "backup", "optimize", "index", "drop_index", "list_indexes", "table_info", "foreign_key_check", "integrity_check" ], "type": "string" }, "backupName": { "description": "Backup file name (without extension)", "type": "string" }, "dbName": { "description": "Database file name (without extension)", "type": "string" }, "indexName": { "description": "Index name", "type": "string" }, "pagination": { "description": "Pagination settings", "properties": { "countTotal": { "default": false, "description": "Count total items", "type": "boolean" }, "page": { "default": 1, "description": "Page number", "minimum": 1, "type": "number" }, "pageSize": { "default": 50, "description": "Items per page", "maximum": 1000, "minimum": 1, "type": "number" } }, "type": "object" }, "params": { "description": "SQL query parameters", "type": "array" }, "query": { "description": "SQL query to execute", "type": "string" }, "tableName": { "description": "Table name", "type": "string" } }, "required": [ "action", "dbName" ], "type": "object" }

You must be authenticated.

Other Tools from ToolBox MCP Server

Related Tools

ID: 1mviic5ax5