Dropping a table takes both the name and a confirm flag that must be true, so it cannot happen as a side effect of a vague instruction. The other thing worth knowing before you plan around it: stored procedures and triggers are out of scope, and file operations and system commands are deliberately absent.
A database server for MCP clients covering four engines, with schema tools and a small notes feature for recording what you learn along the way.
- read_query and write_query — SELECT, and INSERT, UPDATE or DELETE
- create_table, alter_table and drop_table — the last requiring a confirm flag set to true
- list_tables and describe_table for schema exploration
- export_query — query results out as CSV or JSON
- append_insight and list_insights — business observations recorded to a memo as you analyse
- SQLite, SQL Server, PostgreSQL and MySQL from the same binary, chosen by flag
- AWS IAM database authentication for Amazon RDS MySQL, with SSL enabled automatically
Node.js 18+. Install globally as @executeautomation/database-server, or run from source. SQLite takes a file path; the others take --server or --host plus --database, with --user and --password optional — SQL Server falls back to Windows Authentication without them. For RDS IAM auth, pass --aws-iam-auth with --user and --aws-region, and have AWS credentials available through the default provider chain. SQL Server 2012 or later, PostgreSQL 9.5 or later.
One command plus a key — npm install -g @executeautomation/database-server, then supply credentials