Which integrations are available for this server?

Allows querying the CONAPESCA historical landings database stored in MySQL for production deployments. Allows querying the CONAPESCA historical landings database stored in SQLite for local development and testing.

How do I use conapesca-db-mcp?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@conapesca-db-mcp show me the top 10 species by weight in 2023" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

conapesca-db-mcp

by ccalderong

Overview Schema Related Servers Score Discussions

Python

Hybrid

conapesca-db-mcp

MCP server for querying the CONAPESCA historical landings database (2001–2026), covering both the Pacific and Gulf coasts of Mexico.

Exposes tools for extraction and consultation of standardized fishing landings data (avisos de arribo).

Tools available

Data access (raw extraction)

Tool	Description
`get_estados(year?)`	States with landings, optional year filter
`get_species(year?, estado?, tipo_aviso?, top_n?)`	Species list with total weight and value
`species_count()`	Unique scientific names classified by taxonomic level
`get_landings(year?, estado?, especie?, tipo_aviso?, oficina?, limit?, group_by?)`	Landing records or aggregates; `group_by`: `"year"`, `"estado"`, `"litoral"`
`get_offices(estado?)`	CONAPESCA offices with record counts
`get_taxonomy(especie)`	Taxonomy + FishBase traits for a species

Reporting (summaries)

Tool	Description
`landings_by_year(estado?, tipo_aviso?)`	Annual totals: weight, value, species count
`landings_by_estado(year?, tipo_aviso?)`	Totals by state
`landings_by_fleet_type(year?)`	MAYORES vs MENORES vs COSECHA

Core

Tool	Description
`health_check()`	DB connectivity check
`schema_snapshot()`	Column names, types, row count

Related MCP server: @globalfishingwatch/gfw-mcp-js

Quick start (development)

1. Install

pip install -e ".[dev]"

2. Load dev data (SQLite)

python scripts/load_dev_data.py \
  --csv /path/to/conapesca_landings_2001_2026.csv \
  --db dev/conapesca_dev.sqlite \
  --rows 200000   # optional sample for fast testing

3. Configure

cp .env.example .env
# .env already has USE_SQLITE=true by default

4. Run

python -m mcp_server

Production (MySQL)

Set in .env:

USE_SQLITE=false
CONAPESCA_DB_HOST=...
CONAPESCA_DB_USER=...
CONAPESCA_DB_PASSWORD=...
CONAPESCA_DB_NAME=...

The table expected in MySQL is conapesca_landings_historical with the same schema as the pipeline output.

Resources

conapesca://data-dictionary — full column descriptions
conapesca://coverage — temporal and geographic coverage notes

This server cannot be installed

license - not found

quality - not tested

maintenance

How are these scores calculated?

Maintenance

–Maintainers

–Response time

–Release cycle

–Releases (12mo)

Commit activity

Resources

GitHub Repository

Need Help?

Related Servers

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Latest Blog Posts

Lightport: Open-Sourcing Glama's AI Gateway
By punkpeye on April 27, 2026.
OpenAI
open source
Tool Definition Quality Score (TDQS)
By punkpeye on April 3, 2026.
mcp
The Hackers Who Tracked My Sleep Cycle
By punkpeye on March 26, 2026.
security

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/ccalderong/conapesca-db-mcp'

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