Database Tools compatibility with MemCP - Revision history

Wikiservice: Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference

2026-08-28T10:13:56Z

Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference

← Older revision		Revision as of 12:13, 28 August 2026
Line 25:		Line 25:
	Select a MySQL or MariaDB driver, use the configured host and MySQL port (3307 in the documentation examples), and authenticate with a least-privilege MemCP user. Disable driver features that require an unsupported server capability rather than assuming the connection failure is network-related. For the command line:		Select a MySQL or MariaDB driver, use the configured host and MySQL port (3307 in the documentation examples), and authenticate with a least-privilege MemCP user. Disable driver features that require an unsupported server capability rather than assuming the connection failure is network-related. For the command line:

	<~~syntaxhighlight lang="bash"~~>		<pre>
	mysql --protocol=TCP -h 127.0.0.1 -P 3307 -u app_user -p myapp		mysql --protocol=TCP -h 127.0.0.1 -P 3307 -u app_user -p myapp
	</~~syntaxhighlight~~>		</pre>

	When a GUI opens a connection but fails while browsing schemas, capture its first failing metadata statement and reproduce that SQL through the CLI. Tool compatibility often depends on those discovery queries rather than ordinary SELECT/INSERT behavior.		When a GUI opens a connection but fails while browsing schemas, capture its first failing metadata statement and reproduce that SQL through the CLI. Tool compatibility often depends on those discovery queries rather than ordinary SELECT/INSERT behavior.

	''Matrix reviewed against MemCP commit <code>c42e19eba</code> on 27 August 2026; individual GUI versions still require concrete verification.''		''Matrix reviewed against MemCP commit <code>c42e19eba</code> on 27 August 2026; individual GUI versions still require concrete verification.''

Wikiservice: Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference

2026-08-28T09:59:26Z

Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference

← Older revision		Revision as of 11:59, 28 August 2026
Line 1:		Line 1:
	== ~~PHPMyAdmin ==~~		<!-- Copyright (C) 2026 Carl-Philip Haensch -->
	~~no support yet. Read more under: [[Contributing]]~~		<!-- SPDX-License-Identifier: GPL-3.0-or-later -->
			= Database Tools compatibility with MemCP =

	~~== DBeaver ==~~		MemCP speaks the MySQL wire protocol over TCP and a Unix socket. Compatibility depends on both SQL behavior and the metadata queries issued by a particular client version.
	~~Support for:~~

	* List Databases		{\| class="wikitable"
	* List Tables		! Tool !! Connection !! Current status !! Notes
	* SQL ~~Queries~~		\|-
			\| MySQL CLI \|\| MySQL protocol \|\| Supported \|\| Core SQL, prepared statements, SHOW metadata, and process control
			\|-
			\| PDO MySQL \|\| MySQL protocol \|\| Supported \|\| Use the MySQL PDO driver
			\|-
			\| DBeaver \|\| MySQL driver \|\| Supported with limitations \|\| Retest schema editing and metadata against the concrete release
			\|-
			\| PHPMyAdmin \|\| MySQL driver \|\| Compatibility target \|\| Do not claim a version supported without a dated test run
			\|-
			\| VS Code SQLTools \|\| MySQL/MariaDB driver \|\| Supported with limitations \|\| No dedicated MemCP extension is required
			\|}

	* View Tables		MemCP implements prepared statements, selected <code>INFORMATION_SCHEMA</code> relations, SHOW metadata, processlist, TCP, and a Unix socket. It does not claim byte-for-byte MySQL server behavior. Record the MemCP commit, client version, connection mode, and failed metadata query when reporting incompatibility.

	== ~~VSCode SQLTools~~ ==		== Connecting a tool ==
	~~In the moment, you have to use the MySQL / MariaDB connector. A own MemCP connector could be using the REST API, too.~~

	~~Support for~~:		Select a MySQL or MariaDB driver, use the configured host and MySQL port (3307 in the documentation examples), and authenticate with a least-privilege MemCP user. Disable driver features that require an unsupported server capability rather than assuming the connection failure is network-related. For the command line:

	* List Databases		<syntaxhighlight lang="bash">
	* List Tables		mysql --protocol=TCP -h 127.0.0.1 -P 3307 -u app_user -p myapp
	* View Tables		</syntaxhighlight>
	* SQL ~~Queries~~
			When a GUI opens a connection but fails while browsing schemas, capture its first failing metadata statement and reproduce that SQL through the CLI. Tool compatibility often depends on those discovery queries rather than ordinary SELECT/INSERT behavior.

			''Matrix reviewed against MemCP commit <code>c42e19eba</code> on 27 August 2026; individual GUI versions still require concrete verification.''

Carli: /* DBeaver */

2024-05-28T19:25:20Z

DBeaver

← Older revision		Revision as of 21:25, 28 May 2024
Line 8:		Line 8:
	* List Tables		* List Tables
	* SQL Queries		* SQL Queries
	~~TODO:~~

	* View Tables		* View Tables

Carli: /* VSCode SQLTools */

2024-05-20T12:04:26Z

VSCode SQLTools

← Older revision		Revision as of 14:04, 20 May 2024
Line 13:		Line 13:

	== VSCode SQLTools ==		== VSCode SQLTools ==
			In the moment, you have to use the MySQL / MariaDB connector. A own MemCP connector could be using the REST API, too.

	Support for:		Support for:

Carli at 12:03, 20 May 2024

2024-05-20T12:03:17Z

← Older revision		Revision as of 14:03, 20 May 2024
Line 7:		Line 7:
	* List Databases		* List Databases
	* List Tables		* List Tables
			* SQL Queries
			TODO:

			* View Tables

			== VSCode SQLTools ==
			Support for:

			* List Databases
			* List Tables
			* View Tables
			* SQL Queries

Carli: Created page with "== PHPMyAdmin == no support yet. Read more under: Contributing == DBeaver == Support for: * List Databases * List Tables"

2024-05-20T12:02:23Z

Created page with "== PHPMyAdmin == no support yet. Read more under: Contributing == DBeaver == Support for: * List Databases * List Tables"

New page

== PHPMyAdmin ==
no support yet. Read more under: [[Contributing]]

== DBeaver ==
Support for:

* List Databases
* List Tables