# Snowflake timestamp bits, id discarded

> Snowflake timestamp bits, id discarded is an MCP server for databases. MCP server that reads the timestamp bits from Snowflake-style IDs without keeping the ID. It runs as a hosted remote server, so there is nothing to install locally.

- **Kind:** MCP server
- **Platforms:** API
- **Repository:** https://github.com/sadri-dridi/named-mcp-utilities
- **MCP Registry name:** io.github.sadri-dridi/snowflake-ts
- **Categories:** [databases](https://ai-powered.com/categories/databases), [developer tools](https://ai-powered.com/categories/developer-tools)
- **Listing updated:** 2026-11-18

## About

This server exposes a single utility for decoding the time component of Snowflake-format identifiers, the 64-bit IDs used by Twitter, Discord and similar systems. The ID value is discarded after the call, so it is not retained by the tool. The remote endpoint is a streamable HTTP MCP server, so any MCP client that supports that transport can connect to it without a local install.

It is listed as part of a larger set of small, single-purpose MCP utilities published under the same author in one GitHub repository. The README describes each as a separate registry name with its own endpoint. The registry entry does not list a package, a licence or a pricing plan.

The server is aimed at developers and agent builders who need to inspect or validate the timestamp part of a Snowflake ID inside an automated workflow.

## Features

- **Snowflake timestamp extraction:** Returns the timestamp portion encoded in a Snowflake-style identifier.
- **Discards submitted ID:** The identifier value is not kept after the request is processed, according to the listing.
- **Streamable HTTP transport:** Connects over a remote streamable-http MCP endpoint with no local package to install.

## Good for

- Check when a Snowflake-style ID was created during debugging
- Validate timestamp fields inside an agent pipeline without storing raw IDs
- Give an MCP client a narrow utility for ID time decoding

## Install

### Claude Code (Terminal)

```sh
claude mcp add --transport http snowflake-ts https://agent-observatory-sensor.nolimit-observatory.workers.dev/s/snowflake-ts/mcp
```

### Claude Desktop (Settings → Connectors → Add custom connector)

```sh
https://agent-observatory-sensor.nolimit-observatory.workers.dev/s/snowflake-ts/mcp
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "snowflake-ts": {
      "url": "https://agent-observatory-sensor.nolimit-observatory.workers.dev/s/snowflake-ts/mcp"
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "snowflake-ts": {
      "type": "http",
      "url": "https://agent-observatory-sensor.nolimit-observatory.workers.dev/s/snowflake-ts/mcp"
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "snowflake-ts": {
      "serverUrl": "https://agent-observatory-sensor.nolimit-observatory.workers.dev/s/snowflake-ts/mcp"
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "snowflake-ts": {
      "type": "http",
      "url": "https://agent-observatory-sensor.nolimit-observatory.workers.dev/s/snowflake-ts/mcp"
    }
  }
}
```

## FAQ

### How do I add Snowflake timestamp bits, id discarded to Claude Code?

Run this command in your terminal: claude mcp add --transport http snowflake-ts https://agent-observatory-sensor.nolimit-observatory.workers.dev/s/snowflake-ts/mcp

### What are the best alternatives to Snowflake timestamp bits, id discarded?

The closest alternatives to Snowflake timestamp bits, id discarded are Snowflake sequence bits, id discarded, Snowflake worker-id bits, id discarded, Snowflake id shape, XID timestamp prefix, value discarded and shortid charset, value discarded.

## Where this comes from

- Description: written from the project's README and its MCP Registry entry.
- Install steps: from the official MCP Registry entry.

## Alternatives

- [Snowflake sequence bits, id discarded](https://ai-powered.com/mcp/snowflake-sequence-bits-id-discarded): Snowflake sequence bits, id discarded is an open-source MCP server for databases.
- [Snowflake worker-id bits, id discarded](https://ai-powered.com/mcp/snowflake-worker-id-bits-id-discarded): Snowflake worker-id bits, id discarded is an MCP server for databases.
- [Snowflake id shape](https://ai-powered.com/mcp/snowflake-id-shape): Snowflake id shape is an MCP server for databases.
- [XID timestamp prefix, value discarded](https://ai-powered.com/mcp/xid-timestamp-prefix-value-discarded): XID timestamp prefix, value discarded is an MCP server for developer tools.
- [shortid charset, value discarded](https://ai-powered.com/mcp/shortid-charset-value-discarded): shortid charset, value discarded is an MCP server for developer tools.
- [XID Base32 charset, value discarded](https://ai-powered.com/mcp/xid-base32-charset-value-discarded): XID Base32 charset, value discarded is an MCP server for developer tools.
- [Sonyflake digit shape, value discarded](https://ai-powered.com/mcp/sonyflake-digit-shape-value-discarded): Sonyflake digit shape, value discarded is an open-source MCP server for developer tools.
- [SHA-1, input discarded](https://ai-powered.com/mcp/sha-1-input-discarded): SHA-1, input discarded is an MCP server for developer tools.

---
Source: https://ai-powered.com/mcp/snowflake-timestamp-bits-id-discarded
