Skip to main content
Glama
RithikSDev

permit-db

by RithikSDev
OverviewSchemaRelated ServersScoreDiscussions
Python
Local

permit-query-agent

A read-only, natural-language interface to a permit database. Ask a question in plain English; the local Claude Code CLI writes a SELECT, runs it through a validated MCP tool (permit-db), and explains the result. A Streamlit UI wraps it with deterministic Discover/Analytics pages that never call the LLM.

Project Structure

permit-query-agent/
│
├── app/                  # Application source
│   ├── agent/            # PermitAgent — drives the `claude` CLI + MCP tools
│   ├── config/           # Query-safety / logging settings
│   ├── database/         # Engine, session, schema init (connection.py)
│   ├── logging/          # Logging setup
│   ├── mcp/              # MCP server + tool layer (SQL entry point)
│   ├── models/           # SQLAlchemy models
│   ├── repositories/     # Data access layer (queries)
│   ├── security/         # SQL Guard, audit, table allowlist
│   ├── services/         # Query / schema / statistics services
│   └── utils/            # Shared helpers
│
├── ui/                   # Streamlit app (app.py) + deterministic reads (data.py)
├── scripts/              # Setup: init_db, create_readonly_user, seed_data
├── certs/                # DB TLS certs (e.g. Aiven ca.pem) — git-ignored
├── tests/                # Test suite
│
├── .env                  # Local secrets (git-ignored)
├── .env.example          # Copy to .env and fill in
├── .mcp.json             # MCP server configuration
└── requirements.txt

Related MCP server: MCP MySQL Server

Database

MySQL 8, database permit_system (or Aiven's defaultdb). All connection settings are read from .env — see .env.example. Two supported targets:

  • Local MySQL — DB_HOST=localhost, DB_PORT=3306, DB_SSL unset.

  • Aiven for MySQL — the service host/port, DB_SSL=true. Aiven requires TLS; to verify the server cert, download ca.pem into certs/ and set DB_SSL_CA=./certs/aiven-ca.pem.

The app connects as a least-privilege read-only user (DB_USER); setup scripts use the admin credentials (DB_ADMIN_USER / DB_ADMIN_PASSWORD).

Setup

pip install -r requirements.txt
cp .env.example .env            # then fill in host / credentials

python -m app.database.init_db  # create the tables (admin creds)

# create the read-only app user (name defaults to permit_ro)
RO_DB_PASSWORD=your_ro_password python -m scripts.create_readonly_user

python -m scripts.seed_data     # load ~1,000 sample permits

Run

streamlit run ui/app.py         # UI — needs the `claude` CLI on PATH for Ask AI
pytest                          # test suite

This server cannot be installed

RayrunBuild, deploy, and operate MCP servers without becoming an infrastructure team.ray.runAd

Maintenance

ActivityMaintained
ResponsivenessSyncing

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Related MCP Connectors

Related MCP Servers

  • MCP MySQL Server

    keleshteri
    A
    license
    Not graded
    quality
    D
    maintenance
    Enables Claude Desktop to interact with MySQL databases through secure query execution, schema discovery, and multi-database support with configurable read/write permissions and built-in SQL injection protection.
    121
    MIT

  • MySQL MCP Server

    hovecapital
    A
    license
    A
    quality
    C
    maintenance
    Enables Claude Desktop to execute read-only SQL queries on MySQL databases via natural language, with dynamic connection switching and built-in security.
    3
    241
    7
    MIT

  • mcp-mysql-server

    81832310
    A
    license
    A
    quality
    D
    maintenance
    Enables Claude Code to directly operate MySQL databases through natural language, supporting multi-environment profiles, security modes, and 11 tools.
    11
    35
    2
    Apache 2.0

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/RithikSDev/permit-query-agent'

If you have feedback or need assistance with the MCP directory API, please join our Discord server