Skip to main content
Glama

TigerData-mcp-server

by TheSurfingCoder
GitHub
TypeScript
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

MCP TimescaleDB Server

A Model Context Protocol (MCP) server for TimescaleDB Cloud that provides secure access to PostgreSQL databases.

Prerequisites

  • Node.js (v16 or newer recommended)
  • npm (comes with Node.js)
  • TypeScript (installed as a dev dependency, but you may want it globally for development: npm install -g typescript)

A TimescaleDB Cloud account and credentials are also required.

Installation

  1. Install dependencies:
    npm install
  2. Copy the environment template:
    cp .env.example .env
  3. Configure your TimescaleDB credentials in .env:
    TIMESCALE_HOST=your-timescale-host.tsdb.cloud.timescale.com TIMESCALE_PORT=31316 TIMESCALE_DB=tsdb TIMESCALE_USER=tsdbadmin TIMESCALE_PASSWORD=your_password TIMESCALE_SSL_MODE=require

Building

npm run build

Usage

Note: If you are using this server as part of an MCP client (see the "MCP Configuration" section below), you do not need to run npm run dev or npm start manually—the MCP client will launch the server automatically using the specified command. The scripts below are for local development and testing only.

Development

npm run dev

Production

npm run build npm start

MCP Configuration

Add this to your MCP client configuration:

{ "mcpServers": { "mcp-timescale": { "command": "node", "args": ["/path/to/your/dist/index.js"], "env": { "TIMESCALE_HOST": "<your-timescale-host>", "TIMESCALE_PORT": "31316", "TIMESCALE_DB": "tsdb", "TIMESCALE_USER": "tsdbadmin", "TIMESCALE_PASSWORD": "<your-password>", "TIMESCALE_SSL_MODE": "require" } } } }

Security

  • All database connections use SSL/TLS encryption
  • Credentials are managed through environment variables
  • Connection timeouts are configurable
  • Query timeouts prevent long-running queries

Available Tools

timescale_query

Execute SQL queries on TimescaleDB Cloud.

Parameters:

  • query (string, required): SQL query to execute
  • timeout (number, optional): Query timeout in milliseconds

Example:

{ "name": "timescale_query", "arguments": { "query": "SELECT * FROM users LIMIT 10" } }

timescale_list_tables

List all tables in the current database.

Parameters:

  • schema (string, optional): Schema name (defaults to 'public')

Example:

{ "name": "timescale_list_tables", "arguments": { "schema": "public" } }

timescale_describe_table

Get table schema information.

Parameters:

  • table (string, required): Table name
  • schema (string, optional): Schema name (defaults to 'public')

Example:

{ "name": "timescale_describe_table", "arguments": { "table": "users", "schema": "public" } }

Development

Project Structure

TimescaleMCPServer/ ├── package.json # Dependencies and scripts ├── tsconfig.json # TypeScript configuration ├── .env.example # Environment variables template ├── src/ │ ├── index.ts # Main entry point │ ├── server.ts # MCP server implementation │ └── database.ts # Database client └── README.md # This file

This server cannot be installed

-
security - not tested
F
license - not found
-
quality - not tested

How are these scores calculated?

Run queries and pull information about your TigerData Cloud's PostgreSQL databases

  1. Prerequisites
    1. Installation
      1. Building
        1. Usage
          1. Development
          2. Production
        2. MCP Configuration
          1. Security
            1. Available Tools
              1. timescale_query
              2. timescale_list_tables
              3. timescale_describe_table
            2. Development
              1. Project Structure

            Related MCP Servers

            • PostgreSQL MCP Server

              nahmanmate
              A
              security
              A
              license
              A
              quality
              Facilitates management and optimization of PostgreSQL databases, offering analysis, setup guidance, and debugging, while ensuring secure and efficient database operations.
              Last updated -
              3
              1
              16
              TypeScript
              AGPL 3.0
              • Linux
              • Apple

            • MCP PostgreSQL Server

              antonorlov
              A
              security
              A
              license
              A
              quality
              Enables AI models to interact with PostgreSQL databases through a standardized interface, supporting operations like queries, table manipulation, and schema inspection.
              Last updated -
              5
              881
              5
              JavaScript
              MIT License

            • MCP PostgreSQL Server

              Maxim2324
              A
              security
              A
              license
              A
              quality
              A server that connects to PostgreSQL databases and provides tools for safely exploring schemas, running read-only SQL queries, and performing data analysis with pre-built templates.
              Last updated -
              5
              738
              1
              JavaScript
              MIT License

            • Prisma MCP Serverofficial

              prisma
              -
              security
              A
              license
              -
              quality
              Manage Prisma Postgres databases with ease
              Last updated -
              2
              42,953
              TypeScript
              Apache 2.0
              • Linux
              • Apple

            View all related MCP servers

            New 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/TheSurfingCoder/TigerData-mcp-server'

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