sqlite_tool

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

Name	Required	Description
`action`	Yes	Operation type
`backupName`	No	Backup file name (without extension)
`dbName`	Yes	Database file name (without extension)
`indexName`	No	Index name
`pagination`	No	Pagination settings
`params`	No	SQL query parameters
`query`	No	SQL query to execute
`tableName`	No	Table 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"
}

ToolBox MCP Server

Input Schema

Input Schema (JSON Schema)

Other Tools from ToolBox MCP Server

Related Tools