ibex35-mcp

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 to https://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

1. Restart Claude Desktop completely
2. Start a new conversation
3. Ask questions about IBEX 35 data!

Available Tools

Company Data

• get_all_companies - List all IBEX 35 companies with current data
• get_company_by_symbol - Detailed company information by symbol
• get_companies_by_sector - Filter companies by sector
• get_companies_with_pe_ratio - Filter by P/E ratio range

Governance & Leadership

• get_company_directors - Board directors for a company
• get_board_interlocks - Directors serving on multiple boards
• get_directors_by_name - Search directors across all companies

Ownership Analysis

• get_company_shareholders - Shareholder structure for a company
• get_shareholder_overlap - Shareholders with stakes in multiple companies
• get_top_shareholders_by_sector - Top shareholders by sector

Market Data

• get_historical_prices - Historical OHLCV data
• get_top_performers - Best/worst performers over period

News & Sentiment

• get_recent_news - Latest news articles with sentiment
• get_news_by_sentiment - Filter news by sentiment (positive/negative/neutral)

Lobbying & Transparency

• get_lobbying_meetings - EU lobbying meetings and activities
• get_most_active_lobbyists - Organizations with most lobbying activity

Advanced Analytics

• get_network_analysis - Complete network analysis of governance relationships
• get_sector_correlation_analysis - Sector performance correlation analysis

⚡ ENHANCED AI-Powered Analysis

• analyze_natural_query - Process complex natural language queries with intelligent routing
• compare_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 reports
• get_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

1. Check config file location and JSON syntax
2. Restart Claude Desktop completely (⌘+Q, wait, reopen)
3. 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