How do I install Wgong Sqlite?

Copy the http config for Cursor, Claude Desktop, Claude Code, or VS Code on this page. It uses the publisher's install, not a PlugMCP proxy.

Does Wgong Sqlite need an API key?

No required environment variable is listed on this record.

What transport does Wgong Sqlite use?

Wgong Sqlite is reached over HTTP.

When was Wgong Sqlite last checked?

Last checked 2026-11-07. Explore, query, and inspect SQLite databases with ease. List tables, preview results, and view det…

Wgong Sqlite MCP server

Power your agent

Add this server

The publisher's own URL. Not a PlugMCP endpoint.

Add to Cursor Add in Claude Add to VS Code Run on PlugMCP

Host a copy with our keys and logs.

Server URL

https://server.smithery.ai/@wgong/sqlite-mcp-server/mcp

The Claude button above opens Claude with the name and URL filled in. You still confirm it there.

shClaude Code

1claude mcp add --transport http ai.smithery-wgong-sqlite-mcp-server https://server.smithery.ai/@wgong/sqlite-mcp-server/mcp

Run in a terminal.

jsonClaude Desktop

1{2  "mcpServers": {3    "ai.smithery-wgong-sqlite-mcp-server": {4      "command": "npx",5      "args": [6        "-y",7        "mcp-remote",8        "https://server.smithery.ai/@wgong/sqlite-mcp-server/mcp"9      ]10    }11  }12}

claude_desktop_config.json

Remote · HTTPPublisher installStep-by-step: add this in Claude

Remote URL or a command on your machine? How the two installs differ

Run on PlugMCP

Host a copy with our keys and logs.

A new server you create. It is not this listing's official endpoint. Use the publisher install when you want their URL and their credentials.

Launch

Server facts

Remote

Transport: http
Version: 1.16.0
Last checked

Tools

No tool list yet. Remote servers get one after the first health check.

FAQ

Questions

Prerequisites

# Install dependencies
pip install -r requirements.txt

# Install FastMCP globally (if not already installed)
pip install fastmcp

COMMAND CHEATSHEET

# Run FastMCP directly for testing
SQLITE_DB_PATH=/Users/owner/claude-code/agentic-ai-learnings/hw3/sqlite-explorer-fastmcp-mcp-server/financial_data.db fastmcp run sqlite_explorer.py

# Test with inspector (if available)
SQLITE_DB_PATH=/Users/owner/claude-code/agentic-ai-learnings/hw3/sqlite-explorer-fastmcp-mcp-server/financial_data.db fastmcp inspect sqlite_explorer.py

# To install SQLite Explorer
SQLITE_DB_PATH=/Users/owner/claude-code/agentic-ai-learnings/hw3/sqlite-explorer-fastmcp-mcp-server/financial_data.db fastmcp install sqlite_explorer.py --name "SQLite Explorer"

# To launch SQLite Explorer via a web-based testing interface. Run with `--transport sse` for HTTP-based communication  
SQLITE_DB_PATH=/Users/owner/claude-code/agentic-ai-learnings/hw3/sqlite-explorer-fastmcp-mcp-server/financial_data.db fastmcp dev sqlite_explorer.py

# To set up the MCP server with Claude Desktop
SQLITE_DB_PATH=/Users/owner/claude-code/agentic-ai-learnings/hw3/sqlite-explorer-fastmcp-mcp-server/financial_data.db fastmcp claude-desktop add sqlite_explorer.py --name "SQLite Explorer"

# Need to define the SQLITE_DB_PATH variable before running smithery playground 
SQLITE_DB_PATH=/Users/owner/claude-code/agentic-ai-learnings/hw3/sqlite-explorer-fastmcp-mcp-server/financial_data.db smithery playground

After launching Smithery playground, we can now talk to the MCP server using this URL: https://smithery.ai/playground?mcp=https%3A%2F%2Fee09cd8f.ngrok.smithery.ai%2Fmcp

For VSCode with Cline

# Add this configuration to Cline MCP settings:
{
  "sqlite-explorer": {
    "command": "uv",
    "args": [
      "run",
      "--with",
      "fastmcp",
      "--with",
      "uvicorn",
      "fastmcp",
      "run",
      "/Users/owner/claude-code/agentic-ai-learnings/hw3/sqlite-explorer-fastmcp-mcp-server/sqlite_explorer.py"
    ],
    "env": {
      "SQLITE_DB_PATH": "/Users/owner/claude-code/agentic-ai-learnings/hw3/sqlite-explorer-fastmcp-mcp-server/financial_data.db"
    }
  }
}

Example output. MCP server provides four components. SQLite Explorer provides those tools.

Server Name: SQLite Explorer Generation: 2

Components Tools: 3 Prompts: 0 Resources: 0 Templates: 0

Environment FastMCP: 2.12.4 MCP: 1.15.0

This will open an interactive inspector where you can test the MCP tools:

list_tables - to see what tables are in your database
describe_table - to see the structure of a specific table
read_query - to run SELECT queries on your data

Notes

Even though we're running the MCP locally, still have a web interface For locally deployed MCP server SQLite Explorer, this is the MCP server URL that we can access as a client: http://localhost:6274/?MCP_PROXY_AUTH_TOKEN=e01acfa4461c1af5227669c2c0051e7cf9c280fb61a43a146a672463441f4c1b#tools In the future, once deployed, we'll have the same thing - HTTP or HTTPS, but instead of a local host, it'll be my server and the port. The rest will be something else. Local host is the server name, so the server is a local host. But if deployed somewhere, then it'll be a different host name. The port serves as a channel to talk to multiple MCP servers. HTTPS is a secure HTTP.

Sample Questions to Ask Your AI Assistant

Once the MCP server is connected, you can ask questions like:

"What tables are in my database?"
"Show me the structure of my financial data"
"What are the first 10 rows from [table_name]?"
"How many records are in each table?"
"Show me all transactions over $1000"
"What's the average amount in the transactions table?"

NOTE: The tables starting with SQLite are called system tables. We never created those tables.

Troubleshooting

# Check FastMCP version and available commands
fastmcp --help
fastmcp version

# Verify your database file exists
ls -la /Users/owner/claude-code/agentic-ai-learnings/hw3/sqlite-explorer-fastmcp-mcp-server/financial_data.db

# Test database directly with sqlite3
sqlite3 /Users/owner/claude-code/agentic-ai-learnings/hw3/sqlite-explorer-fastmcp-mcp-server/financial_data.db ".tables"

HW 3 Documentation

Step 1

Cloned this GitHub repository: https://github.com/hannesrudolph/sqlite-explorer-fastmcp-mcp-server

Step 2

Asked Claude Code: I was asked to evaluate the following deployment platforms: AWS, Vercel, Railway, and Smithery for my MCP server. I want the simplest and cheapest deployment. Which option should I select?

⏺ Based on your MCP server and requirements, I recommend Smithery.

Here's why:

Simplest: Smithery is specifically designed for MCP servers. It has the most straightforward deployment process for this exact use case.

Cheapest: Smithery offers a free tier for MCP server hosting, making it the most cost-effective option for your SQLite Explorer MCP server.

Other options comparison:

AWS: Most complex setup, requires managing infrastructure, not cost-effective for simple MCP servers
Vercel: Designed for web apps/APIs, not optimized for MCP servers, serverless model may not fit well
Railway: Good platform but more expensive than Smithery's free tier, more general-purpose

For a read-only SQLite MCP server like yours, Smithery's MCP-specific infrastructure is the best match for "simplest and cheapest."

Step 3

Tested this locally via Cline. In VS Code, we configured the system settings to launch a web-based interface with the following JSON file. See URL: http://localhost:6274/?MCP_PROXY_AUTH_TOKEN=a164e503687338cb23938baf05ae738ebe5cd0eaefa629e419cea7ef6ef51563#tools

Step 4

smithery playground URL : https://smithery.ai/playground?mcp=https%3A%2F%2F143c4151.ngrok.smithery.ai%2Fmcp