sqlite-explorer-fastmcp-mcp-server

hannesrudolph/sqlite-explorer-fastmcp-mcp-server

3.9

sqlite-explorer-fastmcp-mcp-server is hosted online, so all tools can be tested directly either in theInspector tabor in theOnline Client.

If you are the rightful owner of sqlite-explorer-fastmcp-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

SQLite Explorer MCP Server provides safe, read-only access to SQLite databases using the FastMCP framework.

Try sqlite-explorer-fastmcp-mcp-server with chat:

Tools

Functions exposed to the LLM to take actions

read_query

Execute a query on the Messages database.

Args:
    query: SELECT SQL query to execute
    params: Optional list of parameters for the query
    fetch_all: If True, fetches all results. If False, fetches one row.
    row_limit: Maximum number of rows to return (default 1000)

Returns:
    List of dictionaries containing the query results

list_tables

List all tables in the Messages database.

Returns:
    List of table names in the database

describe_table

Get detailed information about a table's schema.

Args:
    table_name: Name of the table to describe
    
Returns:
    List of dictionaries containing column information:
    - name: Column name
    - type: Column data type
    - notnull: Whether the column can contain NULL values
    - dflt_value: Default value for the column
    - pk: Whether the column is part of the primary key

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources