v0.2.0rc2 - Production Readiness & Enterprise Deployment

🚀 Release Candidate: Production Readiness & Enterprise Deployment

Release Date: August 6, 2025
Version: 0.2.0rc2
Type: Release Candidate
Installation: pip install nlp2sql==0.2.0rc2

---

📋 Executive Summary

nlp2sql v0.2.0rc2 delivers critical production readiness improvements, addressing containerization challenges, schema management flexibility, and enterprise security requirements. This release candidate focuses on deployment reliability, configuration flexibility, and operational excellence for enterprise environments.

Building upon the multi-provider foundation of v0.2.0rc1, this version ensures seamless deployment across Docker containers, cloud environments, and desktop integration scenarios.

---

🎯 Key Features

🐳 Enterprise Containerization

• Dynamic embeddings configuration via NLP2SQL_EMBEDDINGS_DIR environment variable
• Container-optimized paths eliminating hardcoded directory dependencies
• Multi-environment deployment support (Docker, Kubernetes, bare metal)
• Production-ready working directory handling for containerized workloads

🏢 Advanced Schema Management

• Targeted schema analysis with schema_name parameter for multi-tenant databases
• Flexible embedding storage supporting custom directory structures
• Environment-aware configuration for enterprise deployment patterns
• Improved schema processing with better error handling and validation

🔧 Enhanced MCP Server Integration

• Streamlined function naming for better API consistency:
  • nlp_to_sql - Optimized for natural language processing
  • analyze_schema - Enhanced database introspection
• Container-aware environment handling for cloud deployments
• Comprehensive documentation with real-world examples

🔒 Enterprise Security & DevOps

• GitHub OIDC Trusted Publishing - Eliminates long-lived API tokens
• Automated credential protection with enhanced .gitignore patterns
• Secure CI/CD pipelines with improved GitHub Actions workflows
• Zero-credential-exposure deployment strategies

---

🆕 What's New in v0.2.0rc2

Production-Ready Configuration

# Container-friendly embeddings configuration
import os
os.environ['NLP2SQL_EMBEDDINGS_DIR'] = '/app/data/embeddings'

service = await create_and_initialize_service(
    database_url="postgresql://prod-db/enterprise",
    ai_provider="anthropic",
    api_key="your-api-key"
)

Enhanced MCP Server Integration

# Targeted schema analysis for multi-tenant environments
analyze_schema(
    database_alias="tenant_a_db",
    schema_name="sales_data",  # New parameter
    include_relationships=True
)

Secure CI/CD Deployment

# GitHub Actions with OIDC trusted publishing
- name: Publish to PyPI
  uses: pypa/gh-action-pypi-publish@release/v1
  with:
    # No API tokens required - uses GitHub OIDC
    print-hash: true

---

🏗️ Architecture Improvements

Enterprise Deployment Patterns

• Environment-first configuration - No hardcoded paths or directories
• Container orchestration ready - Kubernetes and Docker Compose support
• Zero-downtime deployments - Backward compatible configuration changes
• Multi-tenant schema isolation - Targeted schema analysis capabilities

Enhanced MCP Server Architecture

• Consistent API naming - Professional function naming conventions
• Improved error handling - Better diagnostics for production debugging
• Documentation completeness - Real-world deployment examples
• Environment variable integration - Cloud-native configuration patterns

Security & DevOps Excellence

• OIDC-based publishing - Eliminates long-lived secret management
• Automated credential scanning - Enhanced .gitignore patterns
• Supply chain security - Verified build and publish workflows
• Zero-trust deployment - No credentials stored in repositories

🔧 Technical Details

Components Updated

• Core nlp2sql library (v0.2.0rc2)
• MCP server (v0.2.0rc2)
• GitHub Actions workflows
• Documentation and examples

Dependencies

• No new dependencies added
• All existing dependencies remain compatible
• Python 3.9+ still required

🚀 Installation & Upgrade

PyPI Installation

pip install nlp2sql==0.2.0rc2

MCP Server Installation

pip install nlp2sql-mcp==0.2.0rc2

Docker

docker pull nlp2sql:0.2.0rc2

🧪 Testing & Validation

This release candidate has been tested with:

• Multiple AI providers (OpenAI, Anthropic, Gemini)
• Various database schemas and configurations
• MCP server integration scenarios
• Enterprise deployment patterns

📋 Migration Notes

From v0.2.0b1

• Environment Variables: Set NLP2SQL_EMBEDDINGS_DIR if using custom embeddings directory
• MCP Server: Update function calls to use new naming convention (nlp_to_sql, analyze_schema)
• No breaking changes to existing API or configuration files

From v0.2.0rc1

• Version bump only: This release only contains version synchronization updates
• All existing configurations remain valid
• No code changes affecting functionality

Configuration Updates

• Optional: Set NLP2SQL_EMBEDDINGS_DIR environment variable for custom embeddings location
• MCP Server: New schema_name parameter available in analyze_schema function
• Existing API keys and settings continue to work unchanged

🐛 Known Issues

• None reported at this time
• Please report issues on GitHub Issues

🤝 Contributing

We welcome contributions! Please see our Contributing Guidelines for details.

📜 Full Changelog

For a complete list of changes, see the GitHub releases page.

🔗 Related Issues

Closes #10 - Create new release candidate v0.2.0rc2

---

Next Steps: This release candidate will be promoted to v0.2.0 stable release after community testing and feedback.