NEACH Data Assistant

☁️ Cloud AI Active — Your questions and database schema names are being sent to Anthropic's servers. Review your data privacy obligations before using cloud models with sensitive data. Current model: Claude

📋 Available Tables

Loading schema…

· ↻ Refresh

📋 TABLES

Suggested:

📝 Suggested Prompts

Each prompt appears in the Chat tab dropdown. You can pin related tables to a prompt — when that prompt is used, the AI will only see those tables in its schema context, making it faster and more accurate. Enable/disable prompts without deleting them.

On	Prompt Text — ⚡ = has saved SQL, runs instantly	Related Tables (optional focus)	🔒	Del

SQL Server Connection Not tested

Server Database

Username Password

🧠 AI Instructions

Each row is injected into every AI prompt. Disable a row to temporarily exclude it without deleting it. Auto-learned entries (JOIN patterns, column mappings) are added automatically during chat — you can edit, disable, or delete them here.

On	Source	Instruction / Note	🔒	Del

🔒 Protected Core Rules (read-only)

Hardcoded safety rules — cannot be changed from the UI.

Live Schema Preview

🔴 Error Log

Last 500 errors — persisted to database, survives restarts.

Time	Source	Status	SQL / Query	Exception
Click Refresh to load errors

📜 Chat History

User:

Sessions

Messages

Select a session to view messages.

📧 Email Configuration

Configure SMTP settings for MFA codes, password reset emails, and future query result delivery.

SMTP Host Port

SMTP Username SMTP Password

From Address From Name

Use STARTTLS Use SSL/TLS (port 465) Email enabled

⚙ AI Model Settings

Choose which AI model generates SQL for your queries. Local (Ollama) models run entirely on your machine — no data leaves your network. Cloud models (Claude) offer higher accuracy but send your query text and schema names to external servers.

Select active model:

Anthropic API Key

Your key is stored in the local SQLite database on this server — it never leaves your network except when making requests to the Claude API. Get a key at console.anthropic.com. Charges apply per query based on Anthropic's current pricing.

No API key stored

☁ Cloud Model Data Notice

When a Claude cloud model is active, every query you submit sends the following to Anthropic's API servers:

Your natural-language question
Your database's table and column names (schema)
AI Instructions you have configured
Conversation history from the current session

Row data is NOT sent — only the structure of your database and your questions.
Review Anthropic's Privacy Policy and your organization's data handling obligations before enabling cloud models.

👤 My Profile

Username Email Address

Enable MFA — send a verification code to my email on each login

Requires a valid email address above.

Change Password

Current Password

New Password Confirm New Password

🧠 My Chat Memory

These entries are injected into every query you run, just for you. Use them to teach the assistant your own terminology — for example "active members means MemberStatus = 'Active'" or "my region is the Northeast chapter". The assistant may also add entries here automatically when you clarify a term during chat.

👥 User Management

Add users and control which tabs they can access. Chat is always granted. Changes take effect on next login.

Username	Password	Email	MFA	Admin	Tab Access	Rm

Admin Account

The admin account (Admin) always has full access.

🔐 Login Log

Failures only

Rolling 30-day history. Tracks all login attempts including bots and failed logins.

Time	Username	IP Address	Result	Reason

📋 Audit Log

All-time audit trail of administrative actions.

Time	Actor	Action	Target	Detail

📊 Report Manager

Create and manage report sets. Each report can be a summary (no record filter) or a master-record report (per-record with benchmarks).

Report

From To

📋 Tables

Pick a table on the left or write SQL above, then click Run.

⏱ Recent Runs

💡 Tips

• Ctrl+Enter to run

• Click a table to explore columns

• Check columns to add to SELECT

• ⊕ adds a WHERE filter

• 🤖 Build with AI generates SQL from plain English

• Read-only — SELECT only

• Save to Prompts for instant replay

NEACH Data Assistant