Skip to main content
Glama

MCP Server Starter

MCP Server

1) Project Directory

Here are the current Project Directory as per updated on 29th August 2025.

mcp-server-starter/ ├─ package.json ├─ tsconfig.json ├─ .gitignore ├─ .env # optional (future auth, db path, etc.) └─ src/ ├─ server/ │ └─ stdio.ts # minimal MCP server (stdio transport) ├─ tools/ │ ├─ sql/ │ │ ├─ index.ts # "run_named_query" tool (registers with server) │ │ └─ templates.ts # allow-listed SQL templates │ └─ index.ts # (barrel) export all tools ├─ db/ │ ├─ seed.ts # create/seed SQLite │ └─ sqlite.ts # tiny DB helper └─ client/ └─ devClient.ts # simple TS client to test the server

2) Initialization of The Project & dependencies Installation

# Change the directory to the project cd mcp-server-starter # 1) Initialize Node project npm init -y # 2) Install runtime deps npm i @modelcontextprotocol/sdk zod better-sqlite3 dotenv # 3) Dev dependencies (TypeScript + runner) npm i -D typescript tsx @types/node # 4) Create a TS config npx tsc --init # 5) Folders mkdir -p src/{server,tools/sql,db,client}
Deploy Server
-
security - not tested
F
license - not found
-
quality - not tested

A starter template for building MCP servers with SQLite database integration. Provides a foundation with SQL query tools, database seeding capabilities, and a development client for testing.

  1. 1. Project Directory
    1. 2. Initialization of The Project & dependencies Installation

      Related MCP Servers

      • A
        security
        A
        license
        A
        quality
        A Model Context Protocol (MCP) server implementation that provides database interaction and business intelligence capabilities through SQLite. This server enables running SQL queries, analyzing business data, and automatically generating business insight memos.
        Last updated -
        6
        66,182
        MIT License
      • -
        security
        F
        license
        -
        quality
        An MCP server that provides safe, read-only access to SQLite databases through MCP. This server is built with the FastMCP framework, which enables LLMs to explore and query SQLite databases with built-in safety features and query validation.
        Last updated -
        83
      • -
        security
        A
        license
        -
        quality
        A template project for building custom MCP servers that enables direct access to PostgreSQL databases, allowing SQL query execution and schema information retrieval through the Model Context Protocol.
        Last updated -
        30
        MIT License
        • Apple
        • Linux
      • -
        security
        A
        license
        -
        quality
        A lightweight MCP server that provides read-only access to SQLite databases, allowing users to execute SELECT queries, list tables, and describe table schemas.
        Last updated -
        MIT License

      View all related MCP servers

      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/Muhammad-Idzhans/mcp-server'

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