科研 Skill
厂商泵性能曲线数据库
pump-performance-db
Accesses manufacturer pump curves and specifications from Grundfos, KSB, and other vendor databases. Use when selecting a pump from a specific manufacturer’s catalog.
SKILL.md
Pump Performance Database
Access manufacturer pump curves and specifications from Grundfos, KSB, and other major pump manufacturers. This skill provides methods for querying pump performance data, parsing manufacturer databases, and creating custom pump libraries.
Overview of Pump Databases
Pump performance databases contain critical information for pump selection and analysis:
- Performance Curves: Flow rate (Q) vs. Head (H) relationships
- Efficiency Curves: Efficiency vs. flow rate
- NPSH Requirements: Net Positive Suction Head Required vs. flow rate
- Power Curves: Power consumption vs. flow rate
- Pump Curves: Multiple impeller diameters and speeds
- Physical Specifications: Size, weight, connection types
- Operating Limits: Temperature, pressure, fluid compatibility
- Selection Data: Model numbers, materials of construction
Manufacturer Resources
Grundfos Product Center
Website: https://product-selection.grundfos.com/
Features:
- Comprehensive product catalog
- WebCAPS online selection tool
- Downloadable product data
- Performance curve exports
- 3D CAD models
- Pump configuration tools
Data Access:
- Web-based selection interface
- PDF datasheets with curves
- Excel export capabilities
- API access (limited, requires partnership)
- Desktop software: Grundfos Product Center (offline)
Typical Data Format:
- Curve data often in proprietary formats
- PDF datasheets require parsing/digitizing
- Some Excel exports with tabular data
KSB EasySelect
Website: https://www.ksb.com/en-us/products-and-solutions/tools-services/easyselect
Features:
- Extensive pump catalog
- Selection based on duty point
- Multiple pump types (centrifugal, positive displacement)
- Performance curve visualization
- Technical documentation
Data Access:
- Web-based selection tool
- Downloadable PDF datasheets
- Limited direct data export
- Desktop application available
Flowserve Pump Selector
Website: https://www.flowserve.com/
Features:
- Industrial pump selection
- Custom engineered pumps
- Extensive API and process pump catalog
- Material selection guidance
Data Access:
- Contact local representative for selection
- PDF technical literature
- Custom quotes for specific applications
- Limited online selection tools
ITT/Goulds Selection Tools
Website: https://www.gouldspumps.com/
Features:
- Industrial and commercial pump selection
- i-ALERT condition monitoring integration
- Performance curve data
- Application-specific pump series
Data Access:
- Goulds Pump Expert software (downloadable)
- Online product catalog
- PDF literature and curves
- Technical support for custom selections
Other Manufacturer Resources
- Xylem/Bell & Gossett: System Syzer web tool
- Armstrong: Pump Manager software
- Wilo: Wilo-Select online selection
- Sulzer: Blue Box online configurator
- Pentair: AquaSuite selection software
- Ebara: E-COMS selection software
Web Scraping Considerations
Legal and Ethical Considerations
Before scraping manufacturer websites:
- Review Terms of Service (ToS)
- Check for robots.txt restrictions
- Respect rate limiting
- Consider requesting API access
- Evaluate if data use complies with licensing
Technical Approaches
PDF Parsing:
# Extract curve data from PDF datasheets
import pdfplumber
import re
import numpy as np
# Digitize performance curves from images
from scipy.interpolate import interp1d
Web Scraping Tools:
- BeautifulSoup for HTML parsing
- Selenium for JavaScript-heavy sites
- Requests for API-like interfaces
- Tabula for PDF table extraction
Challenges:
- Dynamic content loading
- Authentication requirements
- CAPTCHA systems
- Frequent website structure changes
- Data in image format requiring OCR/digitization
API Access
Commercial APIs
Most major manufacturers do not provide public APIs. API access typically requires:
- Partnership Agreements: OEM or distributor relationships
- Enterprise Licensing: Large-scale procurement agreements
- Software Integration: Building applications with manufacturer SDKs
Alternative Data Sources
Third-Party Aggregators:
- Pump selection software (e.g., Selecore, PumpBase)
- Industry databases (requires subscription)
- Engineering software integrations (AFT, PIPE-FLO)
Open Data Projects:
- Research institutions
- University pump databases
- Community-contributed libraries
Data Format and Parsing
Typical Pump Data Structure
{
"model": "CR 10-5",
"manufacturer": "Grundfos",
"type": "Vertical Multistage Centrifugal",
"impeller_diameter": 116, # mm
"speed": 2900, # rpm
"stages": 5,
"performance_curve": {
"flow": [0, 2, 4, 6, 8, 10, 12], # m³/h
"head": [48, 47, 45, 42, 38, 32, 24], # m
"efficiency": [0, 45, 62, 70, 72, 68, 55], # %
"power": [0.8, 1.0, 1.2, 1.4, 1.5, 1.6, 1.7] # kW
},
"npsh_required": {
"flow": [0, 2, 4, 6, 8, 10, 12],
"npsh": [0.5, 0.6, 0.8, 1.2, 1.8, 2.6, 3.6] # m
},
"specifications": {
"min_flow": 0, # m³/h
"max_flow": 12, # m³/h
"max_head": 48, # m
"max_pressure": 16, # bar
"max_temperature": 120, # °C
"connection_size": "DN 32/25",
"materials": {
"casing": "Cast Iron",
"impeller": "Stainless Steel",
"shaft": "Stainless Steel"
}
}
}
Parsing Tabular Data
From Excel/CSV:
import pandas as pd
# Read manufacturer data export
df = pd.read_excel('pump_data.xlsx', sheet_name='Performance')
# Extract curve data
flow = df['Flow_m3h'].values
head = df['Head_m'].values
efficiency = df['Efficiency_pct'].values
From PDF Tables:
import tabula
# Extract tables from PDF
tables = tabula.read_pdf('datasheet.pdf', pages='all')
performance_data = tables[0] # First table
Curve Digitization
Manual Digitization:
- Use WebPlotDigitizer (https://automeris.io/WebPlotDigitizer/)
- Export coordinates to CSV
- Import into Python/Excel
Automated Approaches:
# Image processing for curve extraction
import cv2
from skimage import morphology
import matplotlib.pyplot as plt
# Read curve image
img = cv2.imread('pump_curve.png', 0)
# Threshold and extract curve points
# (Implementation depends on image quality)
Custom Pump Database Creation
Database Structure
SQLite Database Example:
CREATE TABLE manufacturers (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
website TEXT
);
CREATE TABLE pump_models (
id INTEGER PRIMARY KEY,
manufacturer_id INTEGER,
model_number TEXT NOT NULL,
pump_type TEXT,
speed_rpm INTEGER,
stages INTEGER,
impeller_diameter_mm REAL,
FOREIGN KEY (manufacturer_id) REFERENCES manufacturers(id)
);
CREATE TABLE performance_curves (
id INTEGER PRIMARY KEY,
pump_id INTEGER,
flow_m3h REAL,
head_m REAL,
efficiency_pct REAL,
power_kw REAL,
npsh_m REAL,
FOREIGN KEY (pump_id) REFERENCES pump_models(id)
);
CREATE TABLE specifications (
id INTEGER PRIMARY KEY,
pump_id INTEGER,
spec_name TEXT,
spec_value TEXT,
spec_unit TEXT,
FOREIGN KEY (pump_id) REFERENCES pump_models(id)
);
JSON Database Format
{
"database_version": "1.0",
"last_updated": "2025-11-07",
"manufacturers": [
{
"id": "grundfos",
"name": "Grundfos",
"pumps": [
{
"model": "CR 10-5",
"type": "vertical_multistage",
"performance": { ... },
"specifications": { ... }
}
]
}
]
}
Adding Pump Data Programmatically
import sqlite3
import json
class PumpDatabase:
def __init__(self, db_path='pump_database.db'):
self.conn = sqlite3.connect(db_path)
self.create_tables()
def add_pump(self, manufacturer, model, pump_type, curve_data, specs):
"""Add a new pump to the database"""
cursor = self.conn.cursor()
# Get or create manufacturer
cursor.execute(
"INSERT OR IGNORE INTO manufacturers (name) VALUES (?)",
(manufacturer,)
)
cursor.execute(
"SELECT id FROM manufacturers WHERE name = ?",
(manufacturer,)
)
mfg_id = cursor.fetchone()[0]
# Insert pump model
cursor.execute("""
INSERT INTO pump_models
(manufacturer_id, model_number, pump_type, speed_rpm, stages)
VALUES (?, ?, ?, ?, ?)
""", (mfg_id, model, pump_type,
specs.get('speed'), specs.get('stages')))
pump_id = cursor.lastrowid
# Insert performance curve points
for i, flow in enumerate(curve_data['flow']):
cursor.execute("""
INSERT INTO performance_curves
(pump_id, flow_m3h, head_m, efficiency_pct, power_kw)
VALUES (?, ?, ?, ?, ?)
""", (pump_id, flow, curve_data['head'][i],
curve_data['efficiency'][i], curve_data['power'][i]))
self.conn.commit()
Adding Proprietary Pump Data
Data Collection Methods
-
Manufacturer Datasheets:
- Download PDF datasheets
- Extract curve data (digitize if necessary)
- Record specifications
-
Factory Test Data:
- Witness test reports
- Performance verification data
- Actual vs. guaranteed performance
-
Field Measurements:
- Installed pump performance
- In-service efficiency
- Degradation tracking
-
Custom/Modified Pumps:
- Trimmed impellers
- VFD operation at different speeds
- Special configurations
Data Organization
# Directory structure for proprietary data
proprietary_pumps/
├── manufacturer_name/
│ ├── model_series/
│ │ ├── model_variant_1.json
│ │ ├── model_variant_2.json
│ │ └── datasheets/
│ │ ├── model_variant_1.pdf
│ │ └── model_variant_2.pdf
│ └── metadata.json
└── custom_pumps/
├── project_name/
│ ├── pump_1.json
│ └── test_data.csv
└── metadata.json
Version Control for Pump Data
# Include metadata for tracking
{
"model": "CR 10-5",
"data_version": "2.1",
"last_updated": "2025-11-07",
"source": "Grundfos Product Center 2025",
"verified": true,
"verification_date": "2025-10-15",
"notes": "Updated efficiency curve based on factory test data"
}
Best Practices
-
Data Validation:
- Verify curve data makes physical sense
- Check for discontinuities or errors
- Compare against multiple sources when possible
-
Units Management:
- Store data in consistent units (SI preferred)
- Document unit conventions
- Provide conversion utilities
-
Interpolation:
- Use appropriate interpolation for curve queries
- Avoid extrapolation beyond curve limits
- Mark interpolated vs. actual data points
-
Updates and Maintenance:
- Track manufacturer updates
- Version control for database changes
- Archive deprecated models
-
Documentation:
- Source all data properly
- Record assumptions and limitations
- Maintain audit trail for critical selections
Example Workflows
Pump Selection Workflow
- Define Requirements: Flow rate, head, fluid properties
- Query Database: Search for suitable pumps
- Filter Results: By type, size, efficiency
- Evaluate Performance: Check operating point on curve
- Verify NPSH: Ensure adequate suction conditions
- Review Specifications: Materials, temperature, pressure ratings
- Generate Report: Document selection basis
Database Maintenance Workflow
- Monitor Manufacturer Updates: Check for new models/data
- Download New Data: Acquire latest datasheets
- Parse and Validate: Extract and verify curve data
- Update Database: Add new models, update existing
- Version Control: Commit changes with notes
- Notify Users: Document significant changes
Limitations and Considerations
- Manufacturer data copyright: Respect intellectual property
- Data accuracy: Verify critical selections with manufacturer
- Tolerances: Published curves have manufacturing tolerances
- Operating conditions: Curves are for specific fluids (usually water)
- Application-specific: Consult manufacturer for special applications
- Warranty implications: Unofficial data may void warranties
Related Skills
pump-curves: Working with performance curvespump-selection: Systematic pump selection processhydraulic-analysis: System curve and operating point analysisnpsh-analysis: Net Positive Suction Head calculations
示例提示词
帮我查格兰富某型号水泵的厂家性能曲线数据。
所属插件
安装该插件会一并获得同领域的 36 个 Skill / MCP。
同插件的其他科研 Skill
- ANSYS Fluent CFD仿真自动化Automates ANSYS Fluent CFD setup, meshing, and batch runs via Python scripting, journal files, and the PyAnsys ecosystem. Use when a user wants to script or automate an ANSYS Fluent simulation.
- Cantera燃烧仿真Runs Cantera combustion simulations: flame temperature, ignition delay, laminar flame speed, PSR. Use for mechanism-based combustion analysis tasks.
- 离心泵气蚀风险评估Calculates NPSHa and NPSHr and assesses cavitation risk for centrifugal pumps, with prevention and detection guidance. Use when sizing suction piping or diagnosing pump cavitation.
- 气蚀评估物性数据库Looks up vapor pressure, NPSHr data, and correlations for cavitation risk assessment in pumps. Use when cavitation-analysis needs reference property or NPSHr data.
- 离心泵设计计算Designs centrifugal pumps from first principles using Euler equations, velocity triangles, and specific speed. Use for impeller sizing or new centrifugal pump design.
- COMSOL多物理场耦合仿真Sets up coupled fluid-structure interaction simulations in COMSOL Multiphysics, focused on pump vibration analysis. Use when a user wants to script or automate a COMSOL FSI model.
- CoolProp流体物性查询Queries thermodynamic and transport properties for 100+ pure and pseudo-pure fluids via the CoolProp library. Use when a calculation needs fluid density, viscosity, or enthalpy data.
- 工程计算环境初始化Sets up a Python session with engineering constants, Pint units, and plotting defaults. Use at the start of a calculation session.
- 流体计算数值错误校验Handles common numerical errors in fluid calculations, such as division by zero and out-of-range physical values, with validation checks. Use when fluid code fails or returns unphysical results.
- 流体力学分析工作流Guides a systematic fluid dynamics analysis from problem setup and domain definition through model selection to validation. Use when planning a CFD or analytical fluid mechanics study end to end.
- 经验公式流体物性速算Computes quick fluid property estimates (density, viscosity, vapor pressure) from empirical correlations without needing a database. Use for fast order-of-magnitude property checks.
- 管道流动与泵选型计算Computes pipe flow, pump sizing, friction factor, and compressible flow results with the fluids Python package. Use for quick, code-based fluid mechanics calculations.
- 工程工具与数据库清点Enumerates installed Python packages, databases, and simulation tools available in the current environment. Use at the start of a session to avoid recommending unavailable tools.
- 管路元件损失系数查询Looks up loss coefficients (K-values) and equivalent lengths for pipes, valves, and fittings in pump and piping systems. Use when computing system head loss.
- 流体与材料物性查询Looks up temperature-dependent fluid viscosities, densities, and other material properties for pump and heat-transfer calculations. Use when a calculation needs property data at a given temperature.
- 泵性能曲线绘制Creates professional engineering plots such as pump performance curves, CFD velocity contours, and publication-quality figures with matplotlib. Use when a result needs a plotted figure.
- NASA大气与航空流体数据Accesses atmospheric property profiles and standard-atmosphere models from NASA Earthdata for high-altitude and aerospace fluid analysis. Use when a task needs altitude-dependent atmospheric data.
- 管网图论建模Models hydraulic piping networks and multi-pump systems as graphs using NetworkX flow algorithms. Use for analyzing flow distribution across a branched or looped piping network.
- REFPROP高精度物性查询Queries high-accuracy thermodynamic and transport properties from the commercial NIST REFPROP database. Use when a calculation needs reference-quality fluid property data and REFPROP is licensed.
- 数值数组计算Performs numerical array operations with NumPy: velocity field processing, pump curve interpolation, linear systems, and matrix methods. Use for general numerical computation in engineering code.
- OpenFOAM仿真与后处理Runs and post-processes OpenFOAM CFD simulations with PyFoam, pyvista, and vtk for mesh setup, solver control, and visualization. Use for scripted OpenFOAM workflows outside ParaView.
- 泵性能曲线与相似定律Generates and interprets pump H-Q/efficiency/power/NPSH curves, applies affinity laws, and predicts off-design performance. Use for pump curve analysis.
- 工程单位换算与量纲分析Handles engineering units with automatic conversion and dimensional-consistency checking using the Pint library. Use whenever a calculation mixes units or needs unit safety.
- 容积式泵设计分析Designs and analyzes gear, piston, and screw positive-displacement pumps, including volumetric efficiency and slip. Use when the pump is positive-displacement rather than centrifugal.
常见问题
厂商泵性能曲线数据库能做什么?
Accesses manufacturer pump curves and specifications from Grundfos, KSB, and other vendor databases. Use when selecting a pump from a specific manufacturer’s catalog。
如何安装厂商泵性能曲线数据库?
在科搭 Codar 左侧点击「插件」,在「组件」页签搜索「厂商泵性能曲线数据库」并安装;在 Claude Code 或 Codex 中可以发送本页的安装提示词,或下载 Skill 包后解压到 ~/.claude/skills 或 ~/.codex/skills。
厂商泵性能曲线数据库需要哪些权限?
该科研 Skill没有声明额外权限;执行具体操作时仍由 Agent 按自身规则请求确认。
厂商泵性能曲线数据库经过官方审核吗?
是。SpeedSkills 收录的每个版本都会记录内容摘要与权限声明,当前版本已通过安全审核。