Pinax July/August 2025 Update

:woman_astronaut: Summary

The period from July to mid-August was host to a significant overhaul of the Token API, with upgrades to price and swap-related endpoints, as well as SQL query optimizations that improve both data coverage and response times. Solana-based endpoints also saw improvements, with support for the Pump.fun liquidity pool and improved queries that cut response time and expanded data coverage substantially. The Token API MCP server has likewise been updated with comprehensive monitoring and metrics, along with LLM instructions and database descriptions that improve AI data queries.
On the operations side, we completed an infrastructure migration and continued our hard fork support. We also implemented new incident management tools that will improve reliability and reduce issue resolution time, and we continued our marketing tactics through events, blog posts, and organic outreach strategies. These activities align with our mission to support developers with powerful, reliable infrastructure and rich tooling.

:tada: Looking back (what was delivered)

Provided infrastructure for chains currently supported on The Graph and to support protocol integration with new chains.

New blockchains for this period:

  • Tron (RPC)

Token API:

  • Improved OHLC Price Analytics: Implemented configurable quantile support for more accurate high/low price calculations (excluding outliers), with better handling of stablecoin inversions and improved OHLC data integrity.

  • Uniswap V4 Protocol Support: Added full support for Uniswap V4 protocol with enhanced pool parameter validation.

  • Comprehensive Health Monitoring: Introduced detailed health endpoint at /health with database performance metrics, configurable response time thresholds, and optional endpoint testing for operational monitoring.

  • SQL Query Optimizations: Improved balance lookups, enhanced filtering and ordering, and better JOIN operations for more comprehensive data coverage.

  • Developer Experience: Added comprehensive linting/formatting tools, expanded test coverage, and updated core dependencies for better performance and reliability.

  • Database Infrastructure Upgrades: Updated default database versions and added contract databases configuration for better data organization.

  • SVM/Solana Enhancements: Improved SVM balance queries with consistent ordering and better data coverage, and improved Pump.fun liquidity pool support.

  • API Validation & Error Handling Overhaul: Reduced code duplication with a centralized validation system, enhanced error handling and timestamp validation, and upgraded typescript validation library to Zod v4 for improved schema definitions.

  • Breaking Changes:

    • Standardized parameter naming across endpoints for consistency
    • network_id now required for all endpoints (defaults to mainnet)
    • Updated error response formats for better debugging

MCP Updates:

  • Prometheus Metrics Integration: Added comprehensive monitoring capabilities with tool execution tracking, success/failure counters, and performance duration metrics. Includes health check endpoint at /health and metrics endpoint at /metrics for system monitoring.

  • Enhanced Solana Support: New Solana database schemas including solana-dex@v0.2.0 (Jupiter, Pump.fun, Raydium) and solana-tokens@v0.1.0 (SPL token transfers and balance tracking), and added Solana to database update scripts.

  • Configuration Improvements: Added --metrics-port CLI option and METRICS_PORT environment variable support, with configurable hostname for metrics server.

  • Documentation Enhancements: Enhanced table comments and descriptions for 100+ database tables across all supported networks, plus improved instruction prompts clarifying that databases contain complete blockchain history.

  • Monitoring Infrastructure: Integrated OpenTelemetry support and materialized views comments for optimized query performance.

Auxiliary Services:

  • Hard Forks: coordinated and executed node upgrades and recovery actions across Polygon (Heimdall v2 genesis swap + full resync), NEAR testnet, and Scroll mainnet (Feynman readiness), rapidly restoring sync health (stabilizing polygon-arch43) and ensuring stable block production through each cutover.

  • Consolidated our infrastructure and advanced the retirement of a legacy site, boosting reliability and freeing capacity to scale on modern platforms.

  • Implemented new tools to strengthen incident management practices and reduce time to resolution.

Community & Documentation: Education and Support for Indexers and Developers

On the Pinax Blog, we have published a comprehensive guide on building with Hypergraph

  • Building Beyond the Data Silos with Hypergraph

We promoted The Graph’s Token API through organic outreach and growth strategies. We engaged with several platforms for MCP servers to get the Token API server listed. New listings:

  • Glama
  • MCP.so

Additionally, we attended a selection of in-person events such as the Ethereum 10th anniversary (Aachen, Germany & Montreal) and the Superteam Canada 1st Anniversary (Montreal) to promote Firehose, Substreams, and the Token API.

We’ve continued to provide event production support for the weekly Builders Office Hours.

:rocket: Looking ahead (upcoming priorities)

Data Services:

  • Continue to build and add features to the Token API. Share your feedback here.

Infrastructure & Tooling:

  • Publish the public status page for real‑time visibility into service and chain availability.

  • Continue migrations that improve speed, reliability, and scalability, alongside capacity planning for expected growth.

Community & Documentation:

  • Supporting operational tools for indexers

  • Ongoing support on The Graph Discord

  • Ongoing promotion of News related to The Graph in Chinese communities