Uses Cloudflare Workers as the backend infrastructure for edge computing and low latency data access
Synchronizes data from Google Sheets as part of the real-time data pipeline for IBEX 35 market information
Sources information about companies and prominent directors from Wikipedia as part of the comprehensive data aggregation
IBEX 35 MCP Server
A Model Context Protocol (MCP) server that provides Claude and other LLMs with comprehensive access to Spanish IBEX 35 stock market data, corporate governance information, and financial analytics.
π― What This Enables
Transform your AI assistant into a Spanish corporate intelligence expert:
Corporate Governance Analysis - Board compositions, director interlocks, political affiliations
Financial Analytics - Market cap, P/E ratios, sector analysis, performance metrics
Shareholder Intelligence - Ownership structures, institutional holdings, cross-holdings
Board Interlock Detection - Directors serving on multiple boards
Political Connections - Government-appointed directors and political backgrounds
Real-time Market Data - Current prices, volumes, daily changes, historical trends
Perfect for financial research, corporate governance studies, investment analysis, and academic research on Spanish markets.
Features
Core Data Access
Company Information: All IBEX 35 companies with real-time prices and key metrics
Historical Data: OHLCV data, performance tracking, and trend analysis
Shareholders: Ownership structures, concentration analysis, and cross-holdings
Board Directors: Corporate governance, board interlocks, and executive relationships
News & Sentiment: Recent news with sentiment analysis and relevance scoring
ESG Data: Environmental, Social, and Governance scores and metrics
Advanced Analytics β‘ ENHANCED
Natural Language Processing: Ask complex questions in plain English
Company Comparisons: Side-by-side analysis across financial, governance, and performance metrics
Trend Analysis & Forecasting: Advanced price trend analysis with simple forecasting capabilities
Investment Risk Assessment: Comprehensive risk evaluation across market, governance, and operational factors
Analyst Report Generation: Professional company deep-dives, sector overviews, and governance analysis
Investment Opportunity Screening: Filter and rank companies based on custom criteria
Network Analysis: Board interlock analysis, shareholder overlap detection
Governance Risk Assessment: Red flag identification, concentration metrics
Market Correlation: Sector performance analysis and correlation studies
Lobbying Intelligence: EU transparency data and political influence tracking
Special Features
Real-time Sync: Data synchronized from Google Sheets and multiple sources
Weekly Reports: Automated market analysis and governance highlights
Custom Queries: Execute safe SQL queries on the database
Comprehensive Indexing: Optimized for complex relationship queries
π Quick Start
Prerequisites
Node.js 18+
Claude Desktop app (or any MCP-compatible client)
Installation
Option 1: NPM Global Install (Recommended)
Option 2: From Source
Configuration
Environment Variables
IBEX35_API_URL
: URL to your Cloudflare Worker API (defaults tohttps://ibex35-api.ncdata.eu
)IBEX35_API_KEY
: Optional API key for authentication (if your worker requires it)
Cloudflare Worker Setup
The server connects to your existing Cloudflare Worker that provides API access to the D1 database. No local database setup is required.
Usage
Standalone Mode
Claude Desktop Configuration
Add to your claude_desktop_config.json
:
For NPM Install:
For Source Install:
Config file locations:
macOS:
~/Library/Application Support/Claude/claude_desktop_config.json
Windows:
%APPDATA%\Claude\claude_desktop_config.json
Start Using
Restart Claude Desktop completely
Start a new conversation
Ask questions about IBEX 35 data!
Available Tools
Company Data
get_all_companies
- List all IBEX 35 companies with current dataget_company_by_symbol
- Detailed company information by symbolget_companies_by_sector
- Filter companies by sectorget_companies_with_pe_ratio
- Filter by P/E ratio range
Governance & Leadership
get_company_directors
- Board directors for a companyget_board_interlocks
- Directors serving on multiple boardsget_directors_by_name
- Search directors across all companies
Ownership Analysis
get_company_shareholders
- Shareholder structure for a companyget_shareholder_overlap
- Shareholders with stakes in multiple companiesget_top_shareholders_by_sector
- Top shareholders by sector
Market Data
get_historical_prices
- Historical OHLCV dataget_top_performers
- Best/worst performers over period
News & Sentiment
get_recent_news
- Latest news articles with sentimentget_news_by_sentiment
- Filter news by sentiment (positive/negative/neutral)
Lobbying & Transparency
get_lobbying_meetings
- EU lobbying meetings and activitiesget_most_active_lobbyists
- Organizations with most lobbying activity
Advanced Analytics
get_network_analysis
- Complete network analysis of governance relationshipsget_sector_correlation_analysis
- Sector performance correlation analysis
β‘ ENHANCED AI-Powered Analysis
analyze_natural_query
- Process complex natural language queries with intelligent routingcompare_companies
- Multi-dimensional company comparison (financial, governance, performance)analyze_trends
- Advanced trend analysis with forecasting (company, sector, market, correlation)assess_investment_risk
- Comprehensive risk assessment (market, governance, sector, liquidity, concentration)generate_analyst_report
- Professional analyst reports (company deep-dive, sector overview, governance analysis)screen_opportunities
- Investment opportunity screening with custom criteria and scoring
Reporting
get_weekly_reports
- Generated weekly market and governance reportsget_esg_scores
- ESG scores and sustainability metrics
Custom Access
execute_custom_query
- Execute custom SQL queries (SELECT only)
π‘ Example Queries
Once connected, ask Claude natural language questions about IBEX 35 data:
Corporate Governance
Financial Analysis
Shareholder Intelligence
Market Performance
Research & Analysis
β‘ ENHANCED Natural Language Analysis
Security
Read-only Access: Database connection is read-only
Query Restrictions: Only SELECT statements allowed in custom queries
Input Validation: All parameters are validated and sanitized
No Dangerous Operations: DROP, DELETE, UPDATE, etc. are blocked
Database Schema
The server works with a comprehensive schema including:
companies: Core company data and metrics
company_directors: Board and executive information
company_shareholders: Ownership structures
historical_prices: Daily OHLCV market data
company_news: News articles with sentiment analysis
lobbying_meetings: EU transparency and lobbying data
company_esg: ESG scores and sustainability metrics
weekly_reports: Generated analytical reports
Development
Contributing
This MCP server is designed to work with the IBEX 35 Dashboard ecosystem. Ensure any changes maintain compatibility with the existing database schema and sync processes.
π Data Sources
This MCP server aggregates data from authoritative Spanish sources:
Madrid Stock Exchange (BME) - Real-time market data and trading information
CNMV - Official regulatory filings and shareholder disclosures
EU Transparency Register - Corporate lobbying activities and meetings
Corporate Websites - Board compositions and governance structures
Financial News Sources - Market sentiment and company-specific news
π Privacy & Security
No API keys required - Uses publicly available data sources
No personal data - Only publicly disclosed corporate information
No tracking - Direct API access without data collection
Open source - Full transparency in data processing and analysis
Read-only access - Cannot modify or delete any data
π Use Cases
Financial Professionals
Due diligence and investment research
Risk assessment through governance analysis
Market trend identification and sector analysis
Competitive intelligence and benchmarking
Academic Researchers
Corporate governance studies and analysis
Political economy research on Spain
Network analysis of corporate relationships
Financial market behavior studies
Compliance & Risk
Board independence verification
Political connection identification
Ownership concentration analysis
Governance red flag detection
Journalists & Analysts
Investigative research on corporate connections
Political influence mapping
Market analysis and reporting
Corporate transparency assessment
π Troubleshooting
Claude doesn't recognize the server
Check config file location and JSON syntax
Restart Claude Desktop completely (β+Q, wait, reopen)
Verify Node.js version (18+) and installation
Installation issues
API connectivity
The server uses public APIs - no authentication required. If you see errors:
π€ Contributing
Contributions welcome! Areas for enhancement:
Additional data sources and metrics
Performance optimizations
New analytical capabilities
Documentation improvements
π License
MIT License - Free for commercial and non-commercial use.
π Related Resources
IBEX 35 Dashboard - Interactive web interface
Model Context Protocol - Official MCP documentation
Claude Desktop - Download Claude Desktop app
PulseMCP - Discover more MCP servers
π Support & Community
GitHub Issues: Report bugs and request features
GitHub Discussions: Community support and ideas
Web Dashboard: Try the data through the web interface
Model Recommendation: Works best with Claude 4 Sonnet
Made with β€οΈ for the Claude and MCP community
Bringing Spanish corporate intelligence to AI assistants worldwide
remote-capable server
The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.
Tools
Analyze relationships in the Spanish stock exchange
Related MCP Servers
- -securityAlicense-qualityProvides stock market data and trading capabilities using the yfinance libraryLast updated -23MIT License
mcp-spacefrontiersofficial
-securityFlicense-qualitySearch over scholar data and social networksLast updated -66- MIT License